PREVIEW / etf_1hour / 2020-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-08.parquet
  size:    370 KB
  rows:    12,620

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-10-08 04:00:00	SPY	ETF	342.7	342.7	341.53	342.16	36240.0
2020-10-08 05:00:00	SPY	ETF	342.16	342.2	341.72	341.86	17197.0
2020-10-08 06:00:00	SPY	ETF	341.85	343.0	341.85	342.04	55489.0
2020-10-08 07:00:00	SPY	ETF	342.0	342.31	341.81	342.21	224024.0
2020-10-08 08:00:00	SPY	ETF	342.21	343.06	341.95	342.79	543935.0
2020-10-08 09:00:00	SPY	ETF	342.79	343.2099	342.31	343.153	4616600.0
2020-10-08 10:00:00	SPY	ETF	343.18	343.57	342.29	342.99	6370823.0
2020-10-08 11:00:00	SPY	ETF	343.0	343.5	341.86	342.43	6641483.0
2020-10-08 12:00:00	SPY	ETF	342.44	343.47	342.3813	343.32	3189410.0
2020-10-08 13:00:00	SPY	ETF	343.35	343.38	342.87	342.91	2525964.0
2020-10-08 14:00:00	SPY	ETF	342.92	343.68	342.781	343.5	4766805.0
2020-10-08 15:00:00	SPY	ETF	343.51	343.85	343.02	343.73	9187456.0
2020-10-08 16:00:00	SPY	ETF	343.7	344.63	343.48	344.55	5209292.0
2020-10-08 17:00:00	SPY	ETF	344.58	344.6	343.78	344.58	266130.0
2020-10-08 18:00:00	SPY	ETF	344.59	345.45	344.59	345.16	222778.0
2020-10-08 19:00:00	SPY	ETF	345.2	345.3	344.97	345.26	228437.0
2020-10-08 04:00:00	QQQ	ETF	281.82	281.96	281.28	281.71	28481.0
2020-10-08 05:00:00	QQQ	ETF	281.71	282.05	281.41	281.5	30136.0
2020-10-08 06:00:00	QQQ	ETF	281.42	282.01	281.28	281.34	58674.0
2020-10-08 07:00:00	QQQ	ETF	281.3	282.03	281.23	281.89	180929.0
2020-10-08 08:00:00	QQQ	ETF	281.3601	282.5	280.83	282.15	421826.0
2020-10-08 09:00:00	QQQ	ETF	282.18	282.47	280.8801	281.6333	3307315.0
2020-10-08 10:00:00	QQQ	ETF	281.67	281.83	280.31	280.93	3862454.0
2020-10-08 11:00:00	QQQ	ETF	280.95	281.89	280.5	281.221	2888024.0
2020-10-08 12:00:00	QQQ	ETF	281.22	282.13	281.215	281.81	2301402.0
2020-10-08 13:00:00	QQQ	ETF	281.82	281.88	280.76	280.76	1710941.0
2020-10-08 14:00:00	QQQ	ETF	280.77	281.66	280.63	281.427	1584283.0
2020-10-08 15:00:00	QQQ	ETF	281.42	281.58	280.92	281.47	4122459.0
2020-10-08 16:00:00	QQQ	ETF	281.46	282.22	281.29	282.05	1299036.0
2020-10-08 17:00:00	QQQ	ETF	282.04	282.05	281.73	282.0	22644.0
2020-10-08 18:00:00	QQQ	ETF	282.01	282.58	282.0	282.34	167666.0
2020-10-08 19:00:00	QQQ	ETF	282.35	282.52	282.2	282.48	131677.0
2020-10-08 04:00:00	IWM	ETF	160.96	161.22	160.54	160.93	10551.0
2020-10-08 05:00:00	IWM	ETF	160.75	160.75	160.69	160.71	1620.0
2020-10-08 06:00:00	IWM	ETF	160.84	161.3	160.84	161.03	2447.0
2020-10-08 07:00:00	IWM	ETF	161.08	161.25	160.96	161.2	47770.0
2020-10-08 08:00:00	IWM	ETF	161.0899	161.85	160.95	161.7	366794.0
2020-10-08 09:00:00	IWM	ETF	161.74	162.0	161.18	161.64	2741299.0
2020-10-08 10:00:00	IWM	ETF	161.66	162.28	160.98	161.72	4440663.0
2020-10-08 11:00:00	IWM	ETF	161.71	161.89	160.58	160.78	2736006.0
2020-10-08 12:00:00	IWM	ETF	160.78	161.44	160.73	160.95	1718577.0
2020-10-08 13:00:00	IWM	ETF	160.94	161.355	160.81	161.28	1759781.0
2020-10-08 14:00:00	IWM	ETF	161.27	161.92	161.11	161.68	1968086.0
2020-10-08 15:00:00	IWM	ETF	161.67	162.04	161.42	161.84	3713725.0
2020-10-08 16:00:00	IWM	ETF	161.86	162.58	161.68	162.47	11316787.0
2020-10-08 17:00:00	IWM	ETF	162.52	162.79	162.32	162.33	9030.0
2020-10-08 18:00:00	IWM	ETF	162.4	163.11	162.4	163.06	46475.0
2020-10-08 19:00:00	IWM	ETF	162.99	163.06	162.85	163.03	18126.0
2020-10-08 04:00:00	DIA	ETF	284.19	284.46	283.68	284.09	5586.0
2020-10-08 05:00:00	DIA	ETF	283.93	283.94	283.75	283.75	480.0

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

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