PREVIEW / etf_1hour / 2020-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-31.parquet
  size:    380 KB
  rows:    13,028

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-08-31 04:00:00	SPY	ETF	351.71	351.84	351.44	351.74	11732.0
2020-08-31 05:00:00	SPY	ETF	351.74	351.74	351.48	351.63	12316.0
2020-08-31 06:00:00	SPY	ETF	351.5	351.5	351.14	351.29	27145.0
2020-08-31 07:00:00	SPY	ETF	351.29	351.51	351.09	351.25	112931.0
2020-08-31 08:00:00	SPY	ETF	351.25	352.45	350.62	350.75	494444.0
2020-08-31 09:00:00	SPY	ETF	350.74	350.74	349.87	350.03	5782017.0
2020-08-31 10:00:00	SPY	ETF	350.02	350.68	349.85	350.63	8064309.0
2020-08-31 11:00:00	SPY	ETF	350.635	350.85	349.09	350.14	7432510.0
2020-08-31 12:00:00	SPY	ETF	350.15	350.71	350.0	350.51	5003577.0
2020-08-31 13:00:00	SPY	ETF	350.52	350.88	350.35	350.62	4413245.0
2020-08-31 14:00:00	SPY	ETF	350.63	350.88	350.1801	350.78	6423610.0
2020-08-31 15:00:00	SPY	ETF	350.79	351.3	349.31	349.35	15035200.0
2020-08-31 16:00:00	SPY	ETF	349.35	349.96	349.06	349.41	10870712.0
2020-08-31 17:00:00	SPY	ETF	349.5	349.56	349.25	349.45	364797.0
2020-08-31 18:00:00	SPY	ETF	349.32	349.55	348.5	348.91	137220.0
2020-08-31 19:00:00	SPY	ETF	348.95	349.83	348.95	349.69	81291.0
2020-08-31 04:00:00	QQQ	ETF	293.97	294.09	293.35	293.68	63170.0
2020-08-31 05:00:00	QQQ	ETF	293.66	293.73	293.45	293.67	12061.0
2020-08-31 06:00:00	QQQ	ETF	293.58	293.91	293.4	293.86	28912.0
2020-08-31 07:00:00	QQQ	ETF	293.84	293.9	293.15	293.33	296486.0
2020-08-31 08:00:00	QQQ	ETF	293.33	294.64	292.77	292.89	696835.0
2020-08-31 09:00:00	QQQ	ETF	293.0	293.92	292.5	293.57	5137328.0
2020-08-31 10:00:00	QQQ	ETF	293.57	294.93	293.25	294.8	4543228.0
2020-08-31 11:00:00	QQQ	ETF	294.82	295.18	293.135	294.33	4716949.0
2020-08-31 12:00:00	QQQ	ETF	294.33	295.338	294.17	295.3201	2331348.0
2020-08-31 13:00:00	QQQ	ETF	295.3387	296.32	295.18	296.155	2793735.0
2020-08-31 14:00:00	QQQ	ETF	296.16	296.53	295.67	296.5	2684108.0
2020-08-31 15:00:00	QQQ	ETF	296.51	296.745	294.98	294.99	5920703.0
2020-08-31 16:00:00	QQQ	ETF	295.01	300.212	292.5511	295.19	1419368.0
2020-08-31 17:00:00	QQQ	ETF	295.36	295.59	295.2	295.38	29108.0
2020-08-31 18:00:00	QQQ	ETF	295.43	295.76	294.88	295.12	605018.0
2020-08-31 19:00:00	QQQ	ETF	295.23	295.88	295.23	295.8	62029.0
2020-08-31 04:00:00	IWM	ETF	157.8	158.05	157.71	158.05	11820.0
2020-08-31 05:00:00	IWM	ETF	157.92	157.92	157.78	157.78	850.0
2020-08-31 06:00:00	IWM	ETF	157.75	157.8	157.62	157.71	3100.0
2020-08-31 07:00:00	IWM	ETF	157.66	157.91	157.6	157.75	28983.0
2020-08-31 08:00:00	IWM	ETF	157.62	157.73	157.22	157.35	53764.0
2020-08-31 09:00:00	IWM	ETF	157.29	157.37	155.8	155.86	2076849.0
2020-08-31 10:00:00	IWM	ETF	155.86	156.54	155.7	156.1	1549441.0
2020-08-31 11:00:00	IWM	ETF	156.12	156.29	155.32	156.07	1592049.0
2020-08-31 12:00:00	IWM	ETF	156.06	156.12	155.62	155.885	945834.0
2020-08-31 13:00:00	IWM	ETF	155.88	156.29	155.79	156.205	1541192.0
2020-08-31 14:00:00	IWM	ETF	156.2	156.575	156.11	156.4	2765198.0
2020-08-31 15:00:00	IWM	ETF	156.4	156.44	155.31	155.35	3116277.0
2020-08-31 16:00:00	IWM	ETF	155.36	155.74	155.3	155.4	941914.0
2020-08-31 17:00:00	IWM	ETF	155.39	155.5	155.39	155.5	3401.0
2020-08-31 18:00:00	IWM	ETF	155.47	155.57	154.95	155.28	171767.0
2020-08-31 19:00:00	IWM	ETF	155.3	155.52	155.3	155.5	12925.0
2020-08-31 04:00:00	DIA	ETF	287.5	287.5	287.5	287.5	100.0
2020-08-31 05:00:00	DIA	ETF	287.37	287.37	287.34	287.35	1000.0

> showing 50 of 13,028 rows — these rows as CSV

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