PREVIEW / etf_1hour / 2020-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-10.parquet
  size:    374 KB
  rows:    12,837

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-10 04:00:00	SPY	ETF	322.42	322.47	321.42	321.47	53750.0
2020-06-10 05:00:00	SPY	ETF	321.36	321.36	320.2	320.7	61734.0
2020-06-10 06:00:00	SPY	ETF	320.61	321.0	319.6	320.94	131042.0
2020-06-10 07:00:00	SPY	ETF	320.85	321.82	320.65	321.75	325985.0
2020-06-10 08:00:00	SPY	ETF	321.2299	322.71	319.9996	321.95	536446.0
2020-06-10 09:00:00	SPY	ETF	321.92	322.12	319.615	320.29	9260808.0
2020-06-10 10:00:00	SPY	ETF	320.29	320.5967	318.2209	318.7	12669309.0
2020-06-10 11:00:00	SPY	ETF	318.69	320.7769	318.55	319.71	11448173.0
2020-06-10 12:00:00	SPY	ETF	319.76	320.505	319.39	320.23	5583379.0
2020-06-10 13:00:00	SPY	ETF	320.23	320.505	319.79	319.95	4378201.0
2020-06-10 14:00:00	SPY	ETF	319.91	322.39	318.94	319.93	21417895.0
2020-06-10 15:00:00	SPY	ETF	319.94	321.48	318.88	319.01	19869670.0
2020-06-10 16:00:00	SPY	ETF	319.03	319.7647	318.31	318.68	7538667.0
2020-06-10 17:00:00	SPY	ETF	318.67	319.0	318.57	318.59	225646.0
2020-06-10 18:00:00	SPY	ETF	318.6	319.1	317.15	317.39	536026.0
2020-06-10 19:00:00	SPY	ETF	317.35	317.74	316.54	316.76	516439.0
2020-06-10 04:00:00	QQQ	ETF	244.17	244.36	243.99	244.05	35909.0
2020-06-10 05:00:00	QQQ	ETF	244.02	244.02	243.38	243.79	38795.0
2020-06-10 06:00:00	QQQ	ETF	243.71	243.71	243.1	243.69	48765.0
2020-06-10 07:00:00	QQQ	ETF	243.66	244.9	243.63	244.81	242615.0
2020-06-10 08:00:00	QQQ	ETF	243.5796	245.22	243.3896	245.11	457002.0
2020-06-10 09:00:00	QQQ	ETF	245.15	245.68	244.65	245.48	6416242.0
2020-06-10 10:00:00	QQQ	ETF	245.5	245.96	244.51	244.73	8437347.0
2020-06-10 11:00:00	QQQ	ETF	244.75	245.87	244.62	245.33	4053105.0
2020-06-10 12:00:00	QQQ	ETF	245.34	245.85	244.77	245.63	2776573.0
2020-06-10 13:00:00	QQQ	ETF	245.625	245.93	245.25	245.4	2447083.0
2020-06-10 14:00:00	QQQ	ETF	245.39	247.585	244.76	246.41	9805274.0
2020-06-10 15:00:00	QQQ	ETF	246.4	247.815	245.67	246.22	11041695.0
2020-06-10 16:00:00	QQQ	ETF	246.22	246.8475	245.75	246.16	3663081.0
2020-06-10 17:00:00	QQQ	ETF	246.2	246.32	246.03	246.19	53316.0
2020-06-10 18:00:00	QQQ	ETF	246.3	246.6	245.16	245.16	159044.0
2020-06-10 19:00:00	QQQ	ETF	245.16	245.51	244.81	245.06	128212.0
2020-06-10 04:00:00	IWM	ETF	151.55	151.55	150.6	150.67	6400.0
2020-06-10 05:00:00	IWM	ETF	150.62	150.62	149.36	149.91	65809.0
2020-06-10 06:00:00	IWM	ETF	149.73	150.19	148.95	150.09	59649.0
2020-06-10 07:00:00	IWM	ETF	150.15	150.45	149.5	150.44	152957.0
2020-06-10 08:00:00	IWM	ETF	150.06	151.73	149.54	150.52	262920.0
2020-06-10 09:00:00	IWM	ETF	150.54	150.77	147.63	148.265	4552939.0
2020-06-10 10:00:00	IWM	ETF	148.27	148.605	145.9	146.34	9426134.0
2020-06-10 11:00:00	IWM	ETF	146.325	147.6	146.27	147.53	4950546.0
2020-06-10 12:00:00	IWM	ETF	147.589	148.245	147.43	147.675	2422785.0
2020-06-10 13:00:00	IWM	ETF	147.68	147.82	147.28	147.48	1594205.0
2020-06-10 14:00:00	IWM	ETF	147.47	149.25	146.37	146.82	7407131.0
2020-06-10 15:00:00	IWM	ETF	146.82	147.58	146.05	146.13	9739608.0
2020-06-10 16:00:00	IWM	ETF	146.14	146.47	145.64	145.88	3049968.0
2020-06-10 17:00:00	IWM	ETF	145.98	146.18	145.61	145.74	118892.0
2020-06-10 18:00:00	IWM	ETF	145.82	146.18	144.63	144.75	133822.0
2020-06-10 19:00:00	IWM	ETF	144.68	144.89	143.84	144.0	80651.0
2020-06-10 04:00:00	DIA	ETF	274.24	274.59	274.0	274.0	1220.0
2020-06-10 05:00:00	DIA	ETF	273.41	273.41	272.55	272.82	4472.0

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

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