PREVIEW / etf_1hour / 2021-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-16.parquet
  size:    420 KB
  rows:    14,483

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
2021-03-16 04:00:00	SPY	ETF	396.72	396.72	395.95	396.22	17008.0
2021-03-16 05:00:00	SPY	ETF	396.32	396.48	396.21	396.36	6961.0
2021-03-16 06:00:00	SPY	ETF	396.41	396.64	396.39	396.61	15914.0
2021-03-16 07:00:00	SPY	ETF	396.67	397.2	396.65	397.03	139382.0
2021-03-16 08:00:00	SPY	ETF	397.03	397.34	396.36	396.86	255663.0
2021-03-16 09:00:00	SPY	ETF	396.83	397.62	396.72	397.459	5457837.0
2021-03-16 10:00:00	SPY	ETF	397.45	397.83	397.02	397.3	7053656.0
2021-03-16 11:00:00	SPY	ETF	397.315	397.49	396.74	397.049	5665405.0
2021-03-16 12:00:00	SPY	ETF	397.04	397.19	396.03	396.855	6099349.0
2021-03-16 13:00:00	SPY	ETF	396.855	397.38	396.0889	396.275	6317518.0
2021-03-16 14:00:00	SPY	ETF	396.27	396.65	395.08	395.95	10362987.0
2021-03-16 15:00:00	SPY	ETF	395.959	397.02	395.45	395.94	14629992.0
2021-03-16 16:00:00	SPY	ETF	395.95	396.7094	395.83	396.5	4320443.0
2021-03-16 17:00:00	SPY	ETF	396.48	396.55	395.91	396.38	169137.0
2021-03-16 18:00:00	SPY	ETF	396.42	396.75	395.91	396.6	83344.0
2021-03-16 19:00:00	SPY	ETF	396.55	396.7	396.21	396.25	64998.0
2021-03-16 04:00:00	QQQ	ETF	320.44	320.44	319.62	319.68	34119.0
2021-03-16 05:00:00	QQQ	ETF	319.73	320.26	319.64	320.17	27739.0
2021-03-16 06:00:00	QQQ	ETF	320.24	320.5	319.98	320.5	46699.0
2021-03-16 07:00:00	QQQ	ETF	320.5	320.8	320.21	320.65	95773.0
2021-03-16 08:00:00	QQQ	ETF	320.52	321.16	319.96	320.6	248983.0
2021-03-16 09:00:00	QQQ	ETF	320.59	322.78	320.43	322.66	5664953.0
2021-03-16 10:00:00	QQQ	ETF	322.66	324.2	322.3764	323.87	7127866.0
2021-03-16 11:00:00	QQQ	ETF	323.87	324.1	323.03	323.14	4280121.0
2021-03-16 12:00:00	QQQ	ETF	323.18	323.4482	321.34	322.36	4757475.0
2021-03-16 13:00:00	QQQ	ETF	322.37	323.12	321.147	321.6	4286693.0
2021-03-16 14:00:00	QQQ	ETF	321.6	321.975	319.1	320.24	8232682.0
2021-03-16 15:00:00	QQQ	ETF	320.24	321.79	319.67	320.62	7257189.0
2021-03-16 16:00:00	QQQ	ETF	320.61	321.19	320.51	320.97	798420.0
2021-03-16 17:00:00	QQQ	ETF	321.05	321.1	320.58	320.86	143119.0
2021-03-16 18:00:00	QQQ	ETF	320.9	321.43	320.9	321.31	87986.0
2021-03-16 19:00:00	QQQ	ETF	321.24	321.37	320.82	320.83	52943.0
2021-03-16 04:00:00	IWM	ETF	233.62	233.64	233.36	233.54	2893.0
2021-03-16 05:00:00	IWM	ETF	233.43	233.52	233.0	233.0	5010.0
2021-03-16 06:00:00	IWM	ETF	233.27	233.52	233.27	233.52	1470.0
2021-03-16 07:00:00	IWM	ETF	233.48	233.79	233.44	233.7	41794.0
2021-03-16 08:00:00	IWM	ETF	233.5699	234.01	233.42	233.74	100367.0
2021-03-16 09:00:00	IWM	ETF	233.82	234.25	231.73	232.45	2865973.0
2021-03-16 10:00:00	IWM	ETF	232.44	232.66	231.54	231.62	3250461.0
2021-03-16 11:00:00	IWM	ETF	231.61	232.49	231.3	232.47	2252687.0
2021-03-16 12:00:00	IWM	ETF	232.46	232.47	230.71	231.785	2254041.0
2021-03-16 13:00:00	IWM	ETF	231.79	232.2301	231.03	231.11	1484893.0
2021-03-16 14:00:00	IWM	ETF	231.08	231.6	229.12	230.23	3492040.0
2021-03-16 15:00:00	IWM	ETF	230.21	231.06	229.54	230.49	3508324.0
2021-03-16 16:00:00	IWM	ETF	230.5	230.78	230.3	230.53	1353501.0
2021-03-16 17:00:00	IWM	ETF	230.51	230.57	230.4	230.42	91015.0
2021-03-16 18:00:00	IWM	ETF	230.45	230.85	230.39	230.52	44663.0
2021-03-16 19:00:00	IWM	ETF	230.5	230.6	229.93	229.99	40226.0
2021-03-16 04:00:00	DIA	ETF	329.72	329.88	329.61	329.65	1700.0
2021-03-16 05:00:00	DIA	ETF	329.77	329.77	329.54	329.54	1800.0

> showing 50 of 14,483 rows — these rows as CSV

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