PREVIEW / etf_1hour / 2020-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-17.parquet
  size:    371 KB
  rows:    12,656

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-17 04:00:00	SPY	ETF	337.44	337.54	337.0	337.32	24671.0
2020-08-17 05:00:00	SPY	ETF	337.48	337.7	337.2	337.31	6696.0
2020-08-17 06:00:00	SPY	ETF	337.31	337.41	337.17	337.37	22580.0
2020-08-17 07:00:00	SPY	ETF	337.33	337.51	337.17	337.31	165888.0
2020-08-17 08:00:00	SPY	ETF	337.34	337.88	336.6436	337.83	396213.0
2020-08-17 09:00:00	SPY	ETF	337.82	338.17	337.71	337.89	4301268.0
2020-08-17 10:00:00	SPY	ETF	337.89	338.34	337.48	338.02	4129793.0
2020-08-17 11:00:00	SPY	ETF	338.025	338.3	337.73	338.01	3568019.0
2020-08-17 12:00:00	SPY	ETF	338.015	338.191	337.76	338.125	1940773.0
2020-08-17 13:00:00	SPY	ETF	338.16	338.1699	337.96	338.055	2037268.0
2020-08-17 14:00:00	SPY	ETF	338.05	338.16	337.81	337.915	4070730.0
2020-08-17 15:00:00	SPY	ETF	337.91	338.16	337.58	337.88	7812263.0
2020-08-17 16:00:00	SPY	ETF	337.87	338.14	337.62	337.99	5441993.0
2020-08-17 17:00:00	SPY	ETF	338.01	338.05	337.98	338.05	38436.0
2020-08-17 18:00:00	SPY	ETF	338.02	338.07	337.79	338.07	102701.0
2020-08-17 19:00:00	SPY	ETF	338.08	338.79	338.02	338.63	108258.0
2020-08-17 04:00:00	QQQ	ETF	273.28	273.37	273.0	273.16	17420.0
2020-08-17 05:00:00	QQQ	ETF	273.17	273.43	273.12	273.12	9500.0
2020-08-17 06:00:00	QQQ	ETF	273.14	273.33	273.1	273.33	14978.0
2020-08-17 07:00:00	QQQ	ETF	273.33	273.65	273.25	273.3	185059.0
2020-08-17 08:00:00	QQQ	ETF	273.3804	274.02	272.59	273.92	140442.0
2020-08-17 09:00:00	QQQ	ETF	273.84	274.86	273.74	274.78	2460334.0
2020-08-17 10:00:00	QQQ	ETF	274.78	275.07	274.13	274.625	3053750.0
2020-08-17 11:00:00	QQQ	ETF	274.605	274.85	274.17	274.54	1973400.0
2020-08-17 12:00:00	QQQ	ETF	274.54	275.0494	274.34	274.9991	1620477.0
2020-08-17 13:00:00	QQQ	ETF	275.0	275.28	274.89	275.1	1762440.0
2020-08-17 14:00:00	QQQ	ETF	275.09	275.495	274.9343	275.47	1429163.0
2020-08-17 15:00:00	QQQ	ETF	275.47	275.84	275.1	275.27	3297312.0
2020-08-17 16:00:00	QQQ	ETF	275.27	275.47	275.09	275.37	736889.0
2020-08-17 17:00:00	QQQ	ETF	275.37	275.41	275.23	275.33	8159.0
2020-08-17 18:00:00	QQQ	ETF	275.34	275.5	275.23	275.46	27073.0
2020-08-17 19:00:00	QQQ	ETF	275.4	275.85	275.4	275.8	62057.0
2020-08-17 04:00:00	IWM	ETF	157.32	157.36	157.0	157.21	3709.0
2020-08-17 05:00:00	IWM	ETF	157.32	157.32	157.1	157.1	861.0
2020-08-17 06:00:00	IWM	ETF	157.16	157.19	157.02	157.12	4166.0
2020-08-17 07:00:00	IWM	ETF	157.12	157.2	157.0	157.03	66416.0
2020-08-17 08:00:00	IWM	ETF	157.0901	157.42	157.0	157.38	55505.0
2020-08-17 09:00:00	IWM	ETF	157.39	157.665	156.99	157.02	1327238.0
2020-08-17 10:00:00	IWM	ETF	157.04	157.85	156.74	157.4	1109939.0
2020-08-17 11:00:00	IWM	ETF	157.4	157.895	157.32	157.86	893544.0
2020-08-17 12:00:00	IWM	ETF	157.86	157.99	157.71	157.83	737123.0
2020-08-17 13:00:00	IWM	ETF	157.84	157.88	157.54	157.825	800246.0
2020-08-17 14:00:00	IWM	ETF	157.83	158.01	157.69	157.81	698901.0
2020-08-17 15:00:00	IWM	ETF	157.8	158.03	157.66	157.92	2040457.0
2020-08-17 16:00:00	IWM	ETF	157.9	157.96	157.61	157.66	453470.0
2020-08-17 17:00:00	IWM	ETF	157.72	157.86	157.72	157.75	29880.0
2020-08-17 18:00:00	IWM	ETF	157.73	157.73	157.61	157.71	19470.0
2020-08-17 19:00:00	IWM	ETF	157.72	158.15	157.72	158.04	21747.0
2020-08-17 05:00:00	DIA	ETF	279.84	279.84	279.84	279.84	1000.0
2020-08-17 06:00:00	DIA	ETF	279.64	279.65	279.63	279.64	8100.0

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

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