PREVIEW / etf_1hour / 2020-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-11.parquet
  size:    390 KB
  rows:    13,337

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-11 04:00:00	SPY	ETF	336.91	337.84	336.6	337.84	82285.0
2020-08-11 05:00:00	SPY	ETF	337.84	337.93	337.55	337.69	25973.0
2020-08-11 06:00:00	SPY	ETF	337.68	337.75	337.32	337.44	52118.0
2020-08-11 07:00:00	SPY	ETF	337.36	337.7	336.88	336.98	218792.0
2020-08-11 08:00:00	SPY	ETF	337.17	337.85	335.98	337.12	331359.0
2020-08-11 09:00:00	SPY	ETF	337.137	337.27	336.27	336.4	6183277.0
2020-08-11 10:00:00	SPY	ETF	336.39	336.83	335.54	336.6499	7235313.0
2020-08-11 11:00:00	SPY	ETF	336.66	337.21	336.41	336.62	5169325.0
2020-08-11 12:00:00	SPY	ETF	336.63	337.21	336.25	337.0	5372249.0
2020-08-11 13:00:00	SPY	ETF	337.0	337.54	336.8	337.22	4710948.0
2020-08-11 14:00:00	SPY	ETF	337.235	337.385	335.75	336.3199	6173667.0
2020-08-11 15:00:00	SPY	ETF	336.32	336.38	332.01	332.82	25224425.0
2020-08-11 16:00:00	SPY	ETF	332.84	333.87	332.19	333.72	7217480.0
2020-08-11 17:00:00	SPY	ETF	333.65	334.13	333.65	334.13	101595.0
2020-08-11 18:00:00	SPY	ETF	334.0	334.13	333.35	333.66	182388.0
2020-08-11 19:00:00	SPY	ETF	333.6	333.74	333.25	333.37	338541.0
2020-08-11 04:00:00	QQQ	ETF	271.51	272.03	271.32	271.97	34852.0
2020-08-11 05:00:00	QQQ	ETF	272.04	272.16	271.69	271.7	58090.0
2020-08-11 06:00:00	QQQ	ETF	271.69	271.76	271.39	271.4	31220.0
2020-08-11 07:00:00	QQQ	ETF	271.39	271.51	269.79	269.98	400604.0
2020-08-11 08:00:00	QQQ	ETF	270.6	271.6796	268.13	268.89	778990.0
2020-08-11 09:00:00	QQQ	ETF	268.9	269.44	267.35	268.57	5917131.0
2020-08-11 10:00:00	QQQ	ETF	268.57	268.9582	267.0	268.58	5044768.0
2020-08-11 11:00:00	QQQ	ETF	268.58	270.1486	268.57	269.02	3231153.0
2020-08-11 12:00:00	QQQ	ETF	269.03	270.44	268.71	269.89	2609288.0
2020-08-11 13:00:00	QQQ	ETF	269.9	270.14	268.9207	269.46	2740017.0
2020-08-11 14:00:00	QQQ	ETF	269.465	269.65	267.75	268.51	3878967.0
2020-08-11 15:00:00	QQQ	ETF	268.505	268.68	264.63	265.21	9282496.0
2020-08-11 16:00:00	QQQ	ETF	265.18	266.31	264.8	266.2	1385508.0
2020-08-11 17:00:00	QQQ	ETF	266.31	266.68	265.19	266.68	279994.0
2020-08-11 18:00:00	QQQ	ETF	266.74	267.05	266.51	266.67	134120.0
2020-08-11 19:00:00	QQQ	ETF	266.67	266.83	266.41	266.58	75874.0
2020-08-11 04:00:00	IWM	ETF	158.81	159.48	158.68	159.46	19792.0
2020-08-11 05:00:00	IWM	ETF	159.47	159.72	159.34	159.63	47440.0
2020-08-11 06:00:00	IWM	ETF	159.62	159.72	159.51	159.51	20466.0
2020-08-11 07:00:00	IWM	ETF	159.43	159.7	159.35	159.63	160451.0
2020-08-11 08:00:00	IWM	ETF	159.6	159.93	159.41	159.58	416281.0
2020-08-11 09:00:00	IWM	ETF	159.56	159.82	158.91	159.22	3092181.0
2020-08-11 10:00:00	IWM	ETF	159.22	159.54	158.42	159.235	3904816.0
2020-08-11 11:00:00	IWM	ETF	159.24	159.64	159.05	159.36	2776505.0
2020-08-11 12:00:00	IWM	ETF	159.37	159.56	159.01	159.17	1279457.0
2020-08-11 13:00:00	IWM	ETF	159.16	159.73	158.98	159.58	1408004.0
2020-08-11 14:00:00	IWM	ETF	159.58	159.74	158.71	159.24	1748823.0
2020-08-11 15:00:00	IWM	ETF	159.24	159.25	156.16	156.84	5939080.0
2020-08-11 16:00:00	IWM	ETF	156.88	157.57	156.39	157.55	2486374.0
2020-08-11 17:00:00	IWM	ETF	157.58	157.77	157.51	157.51	14564.0
2020-08-11 18:00:00	IWM	ETF	157.62	157.8	157.42	157.59	34530.0
2020-08-11 19:00:00	IWM	ETF	157.6	157.6	157.34	157.48	7565.0
2020-08-11 04:00:00	DIA	ETF	279.99	280.85	279.9	280.85	3360.0
2020-08-11 05:00:00	DIA	ETF	280.75	280.96	280.75	280.96	3658.0

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

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