PREVIEW / etf_1hour / 2020-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-22.parquet
  size:    369 KB
  rows:    12,438

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-22 04:00:00	SPY	ETF	341.94	342.72	341.69	342.3	41816.0
2020-10-22 05:00:00	SPY	ETF	342.33	342.38	342.04	342.19	18692.0
2020-10-22 06:00:00	SPY	ETF	342.02	342.84	341.82	342.58	64494.0
2020-10-22 07:00:00	SPY	ETF	342.56	342.85	342.3	342.75	207305.0
2020-10-22 08:00:00	SPY	ETF	342.7899	343.07	340.51	342.39	603438.0
2020-10-22 09:00:00	SPY	ETF	342.4	343.77	342.28	343.43	3826756.0
2020-10-22 10:00:00	SPY	ETF	343.42	343.5998	340.65	342.24	9693027.0
2020-10-22 11:00:00	SPY	ETF	342.22	343.46	342.09	342.3	6597392.0
2020-10-22 12:00:00	SPY	ETF	342.31	343.29	341.96	343.12	3791526.0
2020-10-22 13:00:00	SPY	ETF	343.12	344.54	343.03	344.33	6359428.0
2020-10-22 14:00:00	SPY	ETF	344.33	345.04	344.2524	344.45	4589480.0
2020-10-22 15:00:00	SPY	ETF	344.45	345.24	343.89	344.63	12863893.0
2020-10-22 16:00:00	SPY	ETF	344.67	345.01	344.33	345.0	5181601.0
2020-10-22 17:00:00	SPY	ETF	344.94	345.28	344.85	345.28	117817.0
2020-10-22 18:00:00	SPY	ETF	345.29	345.56	345.22	345.36	131211.0
2020-10-22 19:00:00	SPY	ETF	345.36	345.38	344.8	345.1	71890.0
2020-10-22 04:00:00	QQQ	ETF	283.95	284.62	283.8	284.23	33621.0
2020-10-22 05:00:00	QQQ	ETF	284.3	284.5	284.12	284.43	9010.0
2020-10-22 06:00:00	QQQ	ETF	284.27	285.0	283.9	284.75	47636.0
2020-10-22 07:00:00	QQQ	ETF	284.79	284.98	284.52	284.82	97526.0
2020-10-22 08:00:00	QQQ	ETF	284.74	285.29	283.48	284.61	298707.0
2020-10-22 09:00:00	QQQ	ETF	284.61	285.98	284.55	284.815	2710495.0
2020-10-22 10:00:00	QQQ	ETF	284.8	284.9599	280.82	282.17	6475552.0
2020-10-22 11:00:00	QQQ	ETF	282.14	283.41	281.71	282.52	3936129.0
2020-10-22 12:00:00	QQQ	ETF	282.56	283.23	281.65	283.12	2026374.0
2020-10-22 13:00:00	QQQ	ETF	283.1	284.6	282.92	284.27	3000445.0
2020-10-22 14:00:00	QQQ	ETF	284.28	284.77	283.91	284.2231	2093579.0
2020-10-22 15:00:00	QQQ	ETF	284.24	285.02	283.52	284.26	3740094.0
2020-10-22 16:00:00	QQQ	ETF	284.29	284.64	283.75	284.4	948956.0
2020-10-22 17:00:00	QQQ	ETF	284.33	284.49	284.1	284.47	61375.0
2020-10-22 18:00:00	QQQ	ETF	284.54	284.94	284.31	284.67	127042.0
2020-10-22 19:00:00	QQQ	ETF	284.68	284.72	284.06	284.56	55874.0
2020-10-22 04:00:00	IWM	ETF	158.93	159.32	158.93	159.32	3200.0
2020-10-22 05:00:00	IWM	ETF	159.41	159.6	159.41	159.57	7520.0
2020-10-22 06:00:00	IWM	ETF	159.38	159.96	159.38	159.9	66480.0
2020-10-22 07:00:00	IWM	ETF	159.91	160.21	159.83	160.1	125840.0
2020-10-22 08:00:00	IWM	ETF	160.13	160.23	159.77	159.94	112104.0
2020-10-22 09:00:00	IWM	ETF	159.88	160.94	159.88	160.7	2046837.0
2020-10-22 10:00:00	IWM	ETF	160.69	160.76	159.18	160.295	2989314.0
2020-10-22 11:00:00	IWM	ETF	160.28	161.17	160.25	160.57	1917233.0
2020-10-22 12:00:00	IWM	ETF	160.57	161.17	160.33	161.09	1060270.0
2020-10-22 13:00:00	IWM	ETF	161.1	161.69	161.07	161.55	1531260.0
2020-10-22 14:00:00	IWM	ETF	161.545	161.9	161.37	161.605	1572528.0
2020-10-22 15:00:00	IWM	ETF	161.6	162.19	161.47	162.14	3802978.0
2020-10-22 16:00:00	IWM	ETF	162.13	162.57	161.936	162.54	907694.0
2020-10-22 17:00:00	IWM	ETF	162.57	162.58	162.37	162.54	57240.0
2020-10-22 18:00:00	IWM	ETF	162.57	162.74	162.54	162.7	85241.0
2020-10-22 19:00:00	IWM	ETF	162.66	162.66	162.23	162.42	37484.0
2020-10-22 04:00:00	DIA	ETF	281.25	281.64	281.25	281.64	950.0
2020-10-22 06:00:00	DIA	ETF	281.21	281.89	281.21	281.89	600.0

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

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