PREVIEW / etf_1hour / 2020-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-08.parquet
  size:    391 KB
  rows:    13,502

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-06-08 04:00:00	SPY	ETF	318.98	320.6	318.9	320.56	68757.0
2020-06-08 05:00:00	SPY	ETF	320.58	320.93	319.96	320.16	57319.0
2020-06-08 06:00:00	SPY	ETF	320.08	320.74	319.84	320.19	58980.0
2020-06-08 07:00:00	SPY	ETF	320.14	321.05	320.13	320.82	346529.0
2020-06-08 08:00:00	SPY	ETF	320.82	321.31	318.66	320.88	551610.0
2020-06-08 09:00:00	SPY	ETF	320.9	321.34	319.34	320.79	11114212.0
2020-06-08 10:00:00	SPY	ETF	320.79	320.93	319.63	320.73	10442834.0
2020-06-08 11:00:00	SPY	ETF	320.75	321.37	320.6	320.85	7269429.0
2020-06-08 12:00:00	SPY	ETF	320.855	321.12	320.48	320.84	4227855.0
2020-06-08 13:00:00	SPY	ETF	320.84	321.91	320.74	321.7627	5554201.0
2020-06-08 14:00:00	SPY	ETF	321.77	322.16	321.62	322.069	7032605.0
2020-06-08 15:00:00	SPY	ETF	322.06	323.41	321.67	323.25	19219931.0
2020-06-08 16:00:00	SPY	ETF	323.24	323.2689	322.63	322.98	6361871.0
2020-06-08 17:00:00	SPY	ETF	322.99	323.3	322.93	323.05	179245.0
2020-06-08 18:00:00	SPY	ETF	323.07	323.07	322.47	322.54	224814.0
2020-06-08 19:00:00	SPY	ETF	322.5399	322.86	322.45	322.61	103449.0
2020-06-08 04:00:00	QQQ	ETF	239.24	239.88	239.16	239.88	150299.0
2020-06-08 05:00:00	QQQ	ETF	239.93	240.04	239.5	239.51	52919.0
2020-06-08 06:00:00	QQQ	ETF	239.49	239.85	239.35	239.55	26797.0
2020-06-08 07:00:00	QQQ	ETF	239.55	239.78	239.24	239.43	153331.0
2020-06-08 08:00:00	QQQ	ETF	239.6	240.37	238.87	239.63	282410.0
2020-06-08 09:00:00	QQQ	ETF	239.68	239.92	238.46	238.83	5172091.0
2020-06-08 10:00:00	QQQ	ETF	238.83	239.46	237.91	239.22	5098902.0
2020-06-08 11:00:00	QQQ	ETF	239.23	239.81	239.151	239.46	3054771.0
2020-06-08 12:00:00	QQQ	ETF	239.47	239.78	239.06	239.66	2168773.0
2020-06-08 13:00:00	QQQ	ETF	239.67	240.63	239.455	240.5635	2830151.0
2020-06-08 14:00:00	QQQ	ETF	240.565	241.03	240.47	240.95	2444006.0
2020-06-08 15:00:00	QQQ	ETF	240.95	241.68	240.58	241.57	5188842.0
2020-06-08 16:00:00	QQQ	ETF	241.56	241.5675	241.02	241.25	1709124.0
2020-06-08 17:00:00	QQQ	ETF	241.26	241.55	241.16	241.29	14580.0
2020-06-08 18:00:00	QQQ	ETF	241.29	241.29	241.03	241.1	44869.0
2020-06-08 19:00:00	QQQ	ETF	241.11	241.35	241.08	241.14	43963.0
2020-06-08 04:00:00	IWM	ETF	150.05	151.55	150.05	151.55	20917.0
2020-06-08 05:00:00	IWM	ETF	151.61	151.95	151.46	151.66	20907.0
2020-06-08 06:00:00	IWM	ETF	151.75	152.55	151.45	151.96	32080.0
2020-06-08 07:00:00	IWM	ETF	151.96	153.05	151.9	152.87	145976.0
2020-06-08 08:00:00	IWM	ETF	152.0901	153.32	149.9	152.38	218993.0
2020-06-08 09:00:00	IWM	ETF	152.39	153.17	152.05	152.9	5453366.0
2020-06-08 10:00:00	IWM	ETF	152.91	152.95	151.63	152.72	5044989.0
2020-06-08 11:00:00	IWM	ETF	152.73	153.29	152.51	152.825	3222230.0
2020-06-08 12:00:00	IWM	ETF	152.83	153.33	152.74	152.93	2259878.0
2020-06-08 13:00:00	IWM	ETF	152.94	153.39	152.89	152.92	1956346.0
2020-06-08 14:00:00	IWM	ETF	152.92	153.06	152.69	152.95	2034607.0
2020-06-08 15:00:00	IWM	ETF	152.95	153.2	152.49	153.07	5122951.0
2020-06-08 16:00:00	IWM	ETF	153.07	153.47	152.86	153.47	1596591.0
2020-06-08 17:00:00	IWM	ETF	153.62	153.62	153.09	153.3	60671.0
2020-06-08 18:00:00	IWM	ETF	153.3	153.32	153.05	153.1	23106.0
2020-06-08 19:00:00	IWM	ETF	153.09	153.3	153.07	153.19	32881.0
2020-06-08 04:00:00	DIA	ETF	271.73	272.82	271.7	272.82	5368.0
2020-06-08 05:00:00	DIA	ETF	273.22	273.45	272.93	272.93	2399.0

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

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