PREVIEW / etf_1hour / 2020-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-15.parquet
  size:    371 KB
  rows:    12,876

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-15 04:00:00	SPY	ETF	320.68	321.08	320.45	320.58	21015.0
2020-07-15 05:00:00	SPY	ETF	320.4	320.58	320.11	320.22	87220.0
2020-07-15 06:00:00	SPY	ETF	320.25	322.23	320.15	322.01	146893.0
2020-07-15 07:00:00	SPY	ETF	322.04	322.88	321.9	322.76	718998.0
2020-07-15 08:00:00	SPY	ETF	322.4801	323.39	320.4	323.26	903974.0
2020-07-15 09:00:00	SPY	ETF	323.25	323.26	321.23	321.88	10761910.0
2020-07-15 10:00:00	SPY	ETF	321.88	323.04	321.13	322.24	11139040.0
2020-07-15 11:00:00	SPY	ETF	322.2465	322.47	319.74	319.75	11622431.0
2020-07-15 12:00:00	SPY	ETF	319.74	321.12	319.265	321.07	10433004.0
2020-07-15 13:00:00	SPY	ETF	321.08	321.78	320.7	321.095	6287839.0
2020-07-15 14:00:00	SPY	ETF	321.1	322.21	320.77	320.92	8059135.0
2020-07-15 15:00:00	SPY	ETF	320.9267	322.59	320.1908	321.865	18308539.0
2020-07-15 16:00:00	SPY	ETF	321.87	322.4	321.62	322.18	7349016.0
2020-07-15 17:00:00	SPY	ETF	322.12	322.31	322.0	322.31	427994.0
2020-07-15 18:00:00	SPY	ETF	322.31	322.8	321.7	321.84	266511.0
2020-07-15 19:00:00	SPY	ETF	321.81	322.17	321.72	321.85	126523.0
2020-07-15 04:00:00	QQQ	ETF	261.11	261.24	260.82	260.89	63743.0
2020-07-15 05:00:00	QQQ	ETF	260.75	260.98	260.3	260.5	107203.0
2020-07-15 06:00:00	QQQ	ETF	260.55	261.81	260.51	261.81	49541.0
2020-07-15 07:00:00	QQQ	ETF	261.81	262.4	261.23	261.46	505109.0
2020-07-15 08:00:00	QQQ	ETF	262.1101	262.37	260.47	261.6	416062.0
2020-07-15 09:00:00	QQQ	ETF	261.64	262.69	260.54	261.28	7075056.0
2020-07-15 10:00:00	QQQ	ETF	261.29	262.52	260.77	261.19	5905930.0
2020-07-15 11:00:00	QQQ	ETF	261.18	261.35	258.01	258.02	8370445.0
2020-07-15 12:00:00	QQQ	ETF	258.01	259.91	257.49	259.79	6243974.0
2020-07-15 13:00:00	QQQ	ETF	259.805	260.43	259.08	259.77	3690835.0
2020-07-15 14:00:00	QQQ	ETF	259.75	261.35	259.41	260.04	4122776.0
2020-07-15 15:00:00	QQQ	ETF	260.05	261.16	259.2	260.78	5633422.0
2020-07-15 16:00:00	QQQ	ETF	260.79	260.9	260.59	260.84	600932.0
2020-07-15 17:00:00	QQQ	ETF	260.74	260.85	260.64	260.8	38085.0
2020-07-15 18:00:00	QQQ	ETF	260.82	261.02	259.44	259.5	202821.0
2020-07-15 19:00:00	QQQ	ETF	259.51	259.95	259.51	259.8	145269.0
2020-07-15 04:00:00	IWM	ETF	143.41	143.85	143.3	143.37	15275.0
2020-07-15 05:00:00	IWM	ETF	143.28	143.45	143.18	143.34	2622.0
2020-07-15 06:00:00	IWM	ETF	143.3	144.82	143.28	144.65	37990.0
2020-07-15 07:00:00	IWM	ETF	144.6	145.44	144.59	145.4	357470.0
2020-07-15 08:00:00	IWM	ETF	145.1801	146.5	143.78	146.25	576091.0
2020-07-15 09:00:00	IWM	ETF	146.26	146.35	144.79	146.08	5485584.0
2020-07-15 10:00:00	IWM	ETF	146.11	147.41	145.2898	147.12	6271031.0
2020-07-15 11:00:00	IWM	ETF	147.105	147.29	145.405	145.43	3754469.0
2020-07-15 12:00:00	IWM	ETF	145.43	146.6	145.06	146.59	3064872.0
2020-07-15 13:00:00	IWM	ETF	146.595	146.94	146.38	146.73	2590177.0
2020-07-15 14:00:00	IWM	ETF	146.72	147.63	146.54	147.01	4162774.0
2020-07-15 15:00:00	IWM	ETF	147.01	147.78	146.78	147.02	6994489.0
2020-07-15 16:00:00	IWM	ETF	147.01	147.58	146.9	147.48	1498331.0
2020-07-15 17:00:00	IWM	ETF	147.41	147.66	147.29	147.65	51402.0
2020-07-15 18:00:00	IWM	ETF	147.65	147.99	147.03	147.35	111763.0
2020-07-15 19:00:00	IWM	ETF	147.36	147.7	147.36	147.42	36227.0
2020-07-15 04:00:00	DIA	ETF	268.89	268.99	268.4	268.56	4600.0
2020-07-15 05:00:00	DIA	ETF	268.4	268.63	268.24	268.4	1100.0

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

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