PREVIEW / etf_1hour / 2020-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-07.parquet
  size:    362 KB
  rows:    12,015

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-01-07 04:00:00	SPY	ETF	324.1	324.13	323.6	323.81	12669.0
2020-01-07 05:00:00	SPY	ETF	323.9	323.91	323.58	323.78	12203.0
2020-01-07 06:00:00	SPY	ETF	323.76	323.93	323.38	323.41	26525.0
2020-01-07 07:00:00	SPY	ETF	323.49	323.8	323.45	323.78	103197.0
2020-01-07 08:00:00	SPY	ETF	323.56	324.2	322.94	322.99	535732.0
2020-01-07 09:00:00	SPY	ETF	322.97	323.29	322.24	322.56	6317922.0
2020-01-07 10:00:00	SPY	ETF	322.58	323.37	322.45	323.2547	5780066.0
2020-01-07 11:00:00	SPY	ETF	323.26	323.54	322.73	322.845	4141213.0
2020-01-07 12:00:00	SPY	ETF	322.845	323.0556	322.71	322.9	2777352.0
2020-01-07 13:00:00	SPY	ETF	322.9	323.15	322.88	323.149	3086704.0
2020-01-07 14:00:00	SPY	ETF	323.15	323.17	322.64	322.99	3049651.0
2020-01-07 15:00:00	SPY	ETF	322.99	323.36	322.5	322.76	9058964.0
2020-01-07 16:00:00	SPY	ETF	322.76	322.807	321.64	322.32	4669965.0
2020-01-07 17:00:00	SPY	ETF	322.33	322.33	322.15	322.24	158740.0
2020-01-07 18:00:00	SPY	ETF	322.15	322.4	318.74	319.47	1191264.0
2020-01-07 19:00:00	SPY	ETF	319.48	319.54	317.25	318.27	1198638.0
2020-01-07 04:00:00	QQQ	ETF	215.9	216.04	215.7	215.83	23085.0
2020-01-07 05:00:00	QQQ	ETF	215.92	215.94	215.67	215.82	20154.0
2020-01-07 06:00:00	QQQ	ETF	215.87	215.98	215.55	215.63	33267.0
2020-01-07 07:00:00	QQQ	ETF	215.61	215.99	215.61	215.92	88276.0
2020-01-07 08:00:00	QQQ	ETF	215.75	216.25	215.3	215.38	204703.0
2020-01-07 09:00:00	QQQ	ETF	215.32	215.89	214.85	215.38	2800006.0
2020-01-07 10:00:00	QQQ	ETF	215.37	215.9	215.05	215.84	3626142.0
2020-01-07 11:00:00	QQQ	ETF	215.84	216.14	215.5766	215.68	2122307.0
2020-01-07 12:00:00	QQQ	ETF	215.68	215.9066	215.57	215.83	960345.0
2020-01-07 13:00:00	QQQ	ETF	215.83	216.06	215.83	216.045	922433.0
2020-01-07 14:00:00	QQQ	ETF	216.05	216.06	215.48	215.71	1394491.0
2020-01-07 15:00:00	QQQ	ETF	215.72	215.95	215.37	215.51	2570171.0
2020-01-07 16:00:00	QQQ	ETF	215.52	215.53	214.64	215.07	1248102.0
2020-01-07 17:00:00	QQQ	ETF	215.05	215.15	215.05	215.05	9815.0
2020-01-07 18:00:00	QQQ	ETF	215.0	215.12	212.27	212.88	554793.0
2020-01-07 19:00:00	QQQ	ETF	212.9	212.92	211.09	211.86	369831.0
2020-01-07 04:00:00	IWM	ETF	165.43	165.43	165.22	165.22	800.0
2020-01-07 05:00:00	IWM	ETF	165.2	165.2	165.2	165.2	400.0
2020-01-07 06:00:00	IWM	ETF	165.35	165.35	164.99	164.99	4500.0
2020-01-07 07:00:00	IWM	ETF	165.08	165.24	165.08	165.24	7700.0
2020-01-07 08:00:00	IWM	ETF	165.17	165.18	164.82	164.82	24627.0
2020-01-07 09:00:00	IWM	ETF	164.77	165.18	164.21	164.4	1450493.0
2020-01-07 10:00:00	IWM	ETF	164.42	165.335	164.37	165.215	1408130.0
2020-01-07 11:00:00	IWM	ETF	165.22	165.315	164.76	164.785	874748.0
2020-01-07 12:00:00	IWM	ETF	164.79	165.19	164.66	164.93	823656.0
2020-01-07 13:00:00	IWM	ETF	164.94	165.08	164.88	165.0	423459.0
2020-01-07 14:00:00	IWM	ETF	165.01	165.03	164.6918	164.89	728618.0
2020-01-07 15:00:00	IWM	ETF	164.88	165.01	164.76	164.81	2392384.0
2020-01-07 16:00:00	IWM	ETF	164.8	164.8527	164.18	164.45	612843.0
2020-01-07 17:00:00	IWM	ETF	164.45	164.5	164.45	164.48	1100.0
2020-01-07 18:00:00	IWM	ETF	164.42	164.8	162.48	162.88	72163.0
2020-01-07 19:00:00	IWM	ETF	162.88	162.88	161.64	162.24	57156.0
2020-01-07 04:00:00	DIA	ETF	287.11	287.11	287.11	287.11	424.0
2020-01-07 05:00:00	DIA	ETF	286.82	286.82	286.82	286.82	200.0

> showing 50 of 12,015 rows — these rows as CSV

> unlock the full archive -- $79 one-time