PREVIEW / etf_1hour / 2020-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-12.parquet
  size:    388 KB
  rows:    13,083

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-11-12 04:00:00	SPY	ETF	354.7	356.26	354.57	356.06	56595.0
2020-11-12 05:00:00	SPY	ETF	356.16	356.86	356.04	356.44	29379.0
2020-11-12 06:00:00	SPY	ETF	356.37	356.81	355.99	355.99	71946.0
2020-11-12 07:00:00	SPY	ETF	355.99	356.1	354.36	354.5	361660.0
2020-11-12 08:00:00	SPY	ETF	354.8801	356.4396	354.01	355.78	403537.0
2020-11-12 09:00:00	SPY	ETF	355.8	355.88	354.67	355.34	5975841.0
2020-11-12 10:00:00	SPY	ETF	355.33	356.39	354.96	356.0	5888908.0
2020-11-12 11:00:00	SPY	ETF	356.0092	356.7182	354.7008	355.25	5390996.0
2020-11-12 12:00:00	SPY	ETF	355.23	355.64	352.51	353.28	7137876.0
2020-11-12 13:00:00	SPY	ETF	353.27	353.5	351.97	353.46	8425258.0
2020-11-12 14:00:00	SPY	ETF	353.46	353.88	351.83	352.0299	8260539.0
2020-11-12 15:00:00	SPY	ETF	352.03	353.33	351.26	353.28	18119677.0
2020-11-12 16:00:00	SPY	ETF	353.27	354.64	353.165	353.87	5253891.0
2020-11-12 17:00:00	SPY	ETF	353.7	353.94	353.7	353.82	300121.0
2020-11-12 18:00:00	SPY	ETF	353.77	353.91	353.2	353.35	426861.0
2020-11-12 19:00:00	SPY	ETF	353.4	353.78	352.68	352.7	182902.0
2020-11-12 04:00:00	QQQ	ETF	289.16	291.36	289.02	291.34	52187.0
2020-11-12 05:00:00	QQQ	ETF	291.45	291.82	291.1	291.23	62186.0
2020-11-12 06:00:00	QQQ	ETF	291.32	291.52	290.79	291.01	60123.0
2020-11-12 07:00:00	QQQ	ETF	290.89	291.06	289.68	290.06	391111.0
2020-11-12 08:00:00	QQQ	ETF	290.21	291.3396	287.96	290.68	421442.0
2020-11-12 09:00:00	QQQ	ETF	290.68	291.83	289.83	290.915	4668495.0
2020-11-12 10:00:00	QQQ	ETF	290.89	292.074	290.46	290.94	3949660.0
2020-11-12 11:00:00	QQQ	ETF	290.95	291.61	289.22	290.105	3110751.0
2020-11-12 12:00:00	QQQ	ETF	290.11	290.62	287.97	288.705	3605515.0
2020-11-12 13:00:00	QQQ	ETF	288.7	289.35	287.51	289.2201	3093711.0
2020-11-12 14:00:00	QQQ	ETF	289.22	289.64	287.74	287.91	3139516.0
2020-11-12 15:00:00	QQQ	ETF	287.92	288.6	287.25	288.42	4841316.0
2020-11-12 16:00:00	QQQ	ETF	288.42	289.5	288.3206	289.37	1240020.0
2020-11-12 17:00:00	QQQ	ETF	289.23	289.31	289.05	289.14	11289.0
2020-11-12 18:00:00	QQQ	ETF	289.22	289.45	288.98	289.05	43368.0
2020-11-12 19:00:00	QQQ	ETF	289.09	289.2	288.5	288.52	73424.0
2020-11-12 04:00:00	IWM	ETF	171.31	172.04	171.23	171.96	16877.0
2020-11-12 05:00:00	IWM	ETF	171.9	172.52	171.78	172.28	26180.0
2020-11-12 06:00:00	IWM	ETF	172.26	172.57	172.14	172.19	14580.0
2020-11-12 07:00:00	IWM	ETF	172.22	172.25	170.82	170.97	112070.0
2020-11-12 08:00:00	IWM	ETF	171.55	172.22	170.63	171.56	156848.0
2020-11-12 09:00:00	IWM	ETF	171.59	171.7	170.37	170.88	4075760.0
2020-11-12 10:00:00	IWM	ETF	170.89	171.91	170.75	171.68	3700170.0
2020-11-12 11:00:00	IWM	ETF	171.685	171.975	171.055	171.24	2132324.0
2020-11-12 12:00:00	IWM	ETF	171.25	171.48	169.56	169.8	4152842.0
2020-11-12 13:00:00	IWM	ETF	169.79	170.25	168.34	170.22	5216802.0
2020-11-12 14:00:00	IWM	ETF	170.22	170.41	168.875	169.03	3061120.0
2020-11-12 15:00:00	IWM	ETF	169.04	169.99	168.38	169.96	5275054.0
2020-11-12 16:00:00	IWM	ETF	169.98	170.36	169.3	169.87	2011694.0
2020-11-12 17:00:00	IWM	ETF	169.42	169.96	169.42	169.71	23116.0
2020-11-12 18:00:00	IWM	ETF	169.83	169.86	169.58	169.65	23973.0
2020-11-12 19:00:00	IWM	ETF	169.63	169.75	169.02	169.05	13909.0
2020-11-12 04:00:00	DIA	ETF	292.36	292.61	292.32	292.61	800.0
2020-11-12 05:00:00	DIA	ETF	292.58	293.33	292.58	292.99	2515.0

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

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