PREVIEW / etf_1hour / 2020-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-16.parquet
  size:    361 KB
  rows:    12,421

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-07-16 04:00:00	SPY	ETF	320.12	320.35	319.2	319.59	70946.0
2020-07-16 05:00:00	SPY	ETF	319.5	319.78	318.92	319.44	53555.0
2020-07-16 06:00:00	SPY	ETF	319.5	319.98	319.38	319.89	62969.0
2020-07-16 07:00:00	SPY	ETF	319.96	320.37	319.73	319.97	317517.0
2020-07-16 08:00:00	SPY	ETF	319.9999	321.15	319.32	319.65	861799.0
2020-07-16 09:00:00	SPY	ETF	319.62	320.46	319.1	319.73	7524760.0
2020-07-16 10:00:00	SPY	ETF	319.7365	320.73	319.09	319.88	8275928.0
2020-07-16 11:00:00	SPY	ETF	319.9	320.3	319.28	319.8	6610295.0
2020-07-16 12:00:00	SPY	ETF	319.78	320.1	319.24	319.7	3847107.0
2020-07-16 13:00:00	SPY	ETF	319.69	320.6	319.6234	319.93	4403248.0
2020-07-16 14:00:00	SPY	ETF	319.93	320.64	319.25	319.37	5319041.0
2020-07-16 15:00:00	SPY	ETF	319.38	321.28	319.21	320.81	12492318.0
2020-07-16 16:00:00	SPY	ETF	320.82	320.95	319.45	319.81	4201818.0
2020-07-16 17:00:00	SPY	ETF	319.67	319.85	319.65	319.79	107813.0
2020-07-16 18:00:00	SPY	ETF	319.89	320.32	319.58	320.3	136894.0
2020-07-16 19:00:00	SPY	ETF	320.3	320.47	320.22	320.41	49573.0
2020-07-16 04:00:00	QQQ	ETF	258.22	258.41	256.88	257.18	112044.0
2020-07-16 05:00:00	QQQ	ETF	257.03	257.03	256.17	256.6	82301.0
2020-07-16 06:00:00	QQQ	ETF	256.65	257.3	255.91	256.94	132093.0
2020-07-16 07:00:00	QQQ	ETF	257.12	257.79	256.85	257.31	277086.0
2020-07-16 08:00:00	QQQ	ETF	257.6	258.94	256.0804	257.58	779038.0
2020-07-16 09:00:00	QQQ	ETF	257.58	258.69	257.14	257.58	4769491.0
2020-07-16 10:00:00	QQQ	ETF	257.61	257.8999	256.28	256.475	7427574.0
2020-07-16 11:00:00	QQQ	ETF	256.49	257.28	255.62	257.26	5125008.0
2020-07-16 12:00:00	QQQ	ETF	257.28	258.0	256.735	257.65	2600061.0
2020-07-16 13:00:00	QQQ	ETF	257.64	258.94	257.5801	258.33	3286792.0
2020-07-16 14:00:00	QQQ	ETF	258.33	259.27	257.95	257.99	3629907.0
2020-07-16 15:00:00	QQQ	ETF	257.99	259.78	257.79	258.98	5048083.0
2020-07-16 16:00:00	QQQ	ETF	258.98	259.12	256.38	257.01	1634469.0
2020-07-16 17:00:00	QQQ	ETF	256.93	257.01	256.8	256.86	99149.0
2020-07-16 18:00:00	QQQ	ETF	256.94	257.73	256.85	257.65	103316.0
2020-07-16 19:00:00	QQQ	ETF	257.68	257.9	257.6	257.82	61149.0
2020-07-16 04:00:00	IWM	ETF	146.42	146.5	145.87	146.22	24539.0
2020-07-16 05:00:00	IWM	ETF	146.19	146.73	145.8	146.67	34397.0
2020-07-16 06:00:00	IWM	ETF	146.6	146.85	146.47	146.61	118622.0
2020-07-16 07:00:00	IWM	ETF	146.68	146.84	146.11	146.16	138183.0
2020-07-16 08:00:00	IWM	ETF	146.5001	146.8096	145.91	146.1	162200.0
2020-07-16 09:00:00	IWM	ETF	146.05	146.55	144.88	145.82	3233264.0
2020-07-16 10:00:00	IWM	ETF	145.825	146.55	145.2487	146.11	3248535.0
2020-07-16 11:00:00	IWM	ETF	146.11	146.67	145.74	146.08	2791090.0
2020-07-16 12:00:00	IWM	ETF	146.07	146.085	145.02	145.125	1757387.0
2020-07-16 13:00:00	IWM	ETF	145.12	145.92	145.05	145.5183	2424992.0
2020-07-16 14:00:00	IWM	ETF	145.51	145.9084	145.2	145.23	1439941.0
2020-07-16 15:00:00	IWM	ETF	145.24	146.17	145.065	146.1	4862546.0
2020-07-16 16:00:00	IWM	ETF	146.11	146.16	145.45	145.79	4611455.0
2020-07-16 17:00:00	IWM	ETF	145.85	145.8999	145.62	145.87	7144.0
2020-07-16 18:00:00	IWM	ETF	145.75	146.25	145.75	146.25	96790.0
2020-07-16 19:00:00	IWM	ETF	146.29	146.34	146.09	146.24	46688.0
2020-07-16 04:00:00	DIA	ETF	266.4	267.4	266.4	267.0	6356.0
2020-07-16 05:00:00	DIA	ETF	266.91	267.29	266.66	267.08	11500.0

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

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