PREVIEW / etf_1hour / 2020-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-20.parquet
  size:    368 KB
  rows:    12,478

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-20 04:00:00	SPY	ETF	344.1	344.41	343.94	343.94	22222.0
2020-10-20 05:00:00	SPY	ETF	344.13	344.4	344.08	344.28	32761.0
2020-10-20 06:00:00	SPY	ETF	344.35	345.01	344.32	344.82	36104.0
2020-10-20 07:00:00	SPY	ETF	344.8	344.87	344.28	344.44	222834.0
2020-10-20 08:00:00	SPY	ETF	344.8	344.95	342.65	343.44	727181.0
2020-10-20 09:00:00	SPY	ETF	343.44	344.879	343.03	344.835	5504015.0
2020-10-20 10:00:00	SPY	ETF	344.82	345.28	343.57	343.58	6087725.0
2020-10-20 11:00:00	SPY	ETF	343.59	344.19	342.64	344.1615	4798051.0
2020-10-20 12:00:00	SPY	ETF	344.17	345.76	344.02	345.08	6624146.0
2020-10-20 13:00:00	SPY	ETF	345.1	346.88	344.99	345.7399	6551028.0
2020-10-20 14:00:00	SPY	ETF	345.735	346.33	344.96	345.05	5608852.0
2020-10-20 15:00:00	SPY	ETF	345.06	345.5599	342.6701	343.34	17052579.0
2020-10-20 16:00:00	SPY	ETF	343.35	343.63	341.81	342.71	5029144.0
2020-10-20 17:00:00	SPY	ETF	342.74	343.38	342.7	343.24	301469.0
2020-10-20 18:00:00	SPY	ETF	343.3	344.18	343.06	344.11	250220.0
2020-10-20 19:00:00	SPY	ETF	344.09	344.84	343.93	344.39	272965.0
2020-10-20 04:00:00	QQQ	ETF	286.11	286.4	285.8	285.9	29953.0
2020-10-20 05:00:00	QQQ	ETF	285.99	286.17	285.72	286.05	20290.0
2020-10-20 06:00:00	QQQ	ETF	286.02	286.66	285.95	286.45	54380.0
2020-10-20 07:00:00	QQQ	ETF	286.46	286.48	285.72	285.89	221696.0
2020-10-20 08:00:00	QQQ	ETF	286.42	286.46	284.15	284.8098	913077.0
2020-10-20 09:00:00	QQQ	ETF	284.79	285.56	283.75	285.49	3558433.0
2020-10-20 10:00:00	QQQ	ETF	285.47	286.29	283.83	283.86	4440492.0
2020-10-20 11:00:00	QQQ	ETF	283.85	284.975	282.95	284.95	3119345.0
2020-10-20 12:00:00	QQQ	ETF	284.94	286.33	284.76	285.68	2884976.0
2020-10-20 13:00:00	QQQ	ETF	285.691	287.62	285.56	286.61	2640916.0
2020-10-20 14:00:00	QQQ	ETF	286.62	287.34	285.9	286.09	2699906.0
2020-10-20 15:00:00	QQQ	ETF	286.14	286.76	283.86	284.47	5785590.0
2020-10-20 16:00:00	QQQ	ETF	284.46	284.81	283.4	284.15	1638782.0
2020-10-20 17:00:00	QQQ	ETF	284.23	284.74	284.2	284.5001	53457.0
2020-10-20 18:00:00	QQQ	ETF	284.74	285.37	284.6	285.37	103299.0
2020-10-20 19:00:00	QQQ	ETF	285.29	285.74	285.18	285.47	220878.0
2020-10-20 04:00:00	IWM	ETF	161.53	161.58	161.38	161.46	5500.0
2020-10-20 05:00:00	IWM	ETF	161.49	161.7	161.49	161.68	8600.0
2020-10-20 06:00:00	IWM	ETF	161.66	162.01	161.6	161.98	15715.0
2020-10-20 07:00:00	IWM	ETF	161.99	162.05	161.75	161.8	35882.0
2020-10-20 08:00:00	IWM	ETF	162.02	162.02	160.95	161.43	46776.0
2020-10-20 09:00:00	IWM	ETF	161.4	162.4307	161.33	162.42	1969740.0
2020-10-20 10:00:00	IWM	ETF	162.41	162.45	161.2	161.32	1973484.0
2020-10-20 11:00:00	IWM	ETF	161.3175	162.07	160.91	161.87	1382997.0
2020-10-20 12:00:00	IWM	ETF	161.85	162.35	161.32	162.165	2356645.0
2020-10-20 13:00:00	IWM	ETF	162.17	162.43	161.63	161.83	2033726.0
2020-10-20 14:00:00	IWM	ETF	161.84	162.06	161.3	161.3	1157198.0
2020-10-20 15:00:00	IWM	ETF	161.31	161.45	160.34	160.74	3842565.0
2020-10-20 16:00:00	IWM	ETF	160.76	160.89	159.76	160.44	1637934.0
2020-10-20 17:00:00	IWM	ETF	160.4	160.7	160.35	160.7	22923.0
2020-10-20 18:00:00	IWM	ETF	160.74	161.1	160.71	160.95	30948.0
2020-10-20 19:00:00	IWM	ETF	161.14	161.56	161.08	161.2	28006.0
2020-10-20 05:00:00	DIA	ETF	283.28	283.28	283.28	283.28	100.0
2020-10-20 06:00:00	DIA	ETF	283.63	283.92	283.63	283.92	1600.0

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

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