PREVIEW / etf_1hour / 2019-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-30.parquet
  size:    360 KB
  rows:    11,929

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
2019-12-30 04:00:00	SPY	ETF	323.11	323.15	322.89	322.91	39772.0
2019-12-30 05:00:00	SPY	ETF	322.94	322.94	322.71	322.74	2376.0
2019-12-30 06:00:00	SPY	ETF	322.66	322.68	322.45	322.67	60329.0
2019-12-30 07:00:00	SPY	ETF	322.71	322.86	322.71	322.73	71443.0
2019-12-30 08:00:00	SPY	ETF	322.8	323.09	322.53	323.02	192089.0
2019-12-30 09:00:00	SPY	ETF	323.01	323.15	321.29	321.47	7597722.0
2019-12-30 10:00:00	SPY	ETF	321.4705	321.63	320.55	321.21	7923154.0
2019-12-30 11:00:00	SPY	ETF	321.215	321.6	320.85	321.47	4372548.0
2019-12-30 12:00:00	SPY	ETF	321.46	322.06	321.43	321.8315	4855953.0
2019-12-30 13:00:00	SPY	ETF	321.83	321.91	321.51	321.73	3607180.0
2019-12-30 14:00:00	SPY	ETF	321.735	321.745	321.105	321.15	4345158.0
2019-12-30 15:00:00	SPY	ETF	321.15	321.43	320.7	321.1	9236242.0
2019-12-30 16:00:00	SPY	ETF	321.11	321.33	321.0677	321.19	6008995.0
2019-12-30 17:00:00	SPY	ETF	321.19	321.19	321.09	321.16	17204.0
2019-12-30 18:00:00	SPY	ETF	321.14	321.29	321.08	321.29	91807.0
2019-12-30 19:00:00	SPY	ETF	321.28	321.38	321.27	321.38	35714.0
2019-12-30 04:00:00	QQQ	ETF	213.86	213.86	213.62	213.62	16127.0
2019-12-30 05:00:00	QQQ	ETF	213.62	213.63	213.42	213.48	10658.0
2019-12-30 06:00:00	QQQ	ETF	213.37	213.47	213.24	213.43	25375.0
2019-12-30 07:00:00	QQQ	ETF	213.47	213.63	213.47	213.51	47092.0
2019-12-30 08:00:00	QQQ	ETF	213.51	213.7	213.41	213.63	156170.0
2019-12-30 09:00:00	QQQ	ETF	213.57	213.68	211.47	211.72	4200590.0
2019-12-30 10:00:00	QQQ	ETF	211.73	211.99	211.16	211.91	3507266.0
2019-12-30 11:00:00	QQQ	ETF	211.92	212.34	211.59	212.27	1605361.0
2019-12-30 12:00:00	QQQ	ETF	212.26	212.76	212.24	212.6499	1318763.0
2019-12-30 13:00:00	QQQ	ETF	212.62	212.695	212.43	212.61	1355863.0
2019-12-30 14:00:00	QQQ	ETF	212.61	212.62	212.12	212.19	1176935.0
2019-12-30 15:00:00	QQQ	ETF	212.17	212.4155	211.89	212.16	2330750.0
2019-12-30 16:00:00	QQQ	ETF	212.18	212.31	211.52	212.18	1131583.0
2019-12-30 17:00:00	QQQ	ETF	212.26	212.26	212.15	212.21	7674.0
2019-12-30 18:00:00	QQQ	ETF	212.2	212.27	212.1	212.25	12551.0
2019-12-30 19:00:00	QQQ	ETF	212.25	212.33	212.25	212.31	8050.0
2019-12-30 04:00:00	IWM	ETF	165.98	165.98	165.95	165.95	5700.0
2019-12-30 05:00:00	IWM	ETF	165.95	165.95	165.83	165.88	3200.0
2019-12-30 06:00:00	IWM	ETF	165.84	165.84	165.77	165.77	3050.0
2019-12-30 07:00:00	IWM	ETF	165.89	165.97	165.89	165.94	7900.0
2019-12-30 08:00:00	IWM	ETF	165.92	166.07	165.86	165.99	16978.0
2019-12-30 09:00:00	IWM	ETF	165.99	166.205	164.7	165.11	2041338.0
2019-12-30 10:00:00	IWM	ETF	165.12	165.29	164.57	165.21	2181068.0
2019-12-30 11:00:00	IWM	ETF	165.21	165.77	164.9658	165.535	1066983.0
2019-12-30 12:00:00	IWM	ETF	165.535	166.12	165.49	165.99	1007659.0
2019-12-30 13:00:00	IWM	ETF	165.97	166.035	165.88	165.94	559306.0
2019-12-30 14:00:00	IWM	ETF	165.94	165.94	165.42	165.43	756162.0
2019-12-30 15:00:00	IWM	ETF	165.42	165.62	165.34	165.5	2011455.0
2019-12-30 16:00:00	IWM	ETF	165.49	165.64	165.4	165.43	1606403.0
2019-12-30 17:00:00	IWM	ETF	165.48	165.48	165.4	165.4	62484.0
2019-12-30 18:00:00	IWM	ETF	165.45	165.49	165.45	165.48	4382.0
2019-12-30 19:00:00	IWM	ETF	165.55	165.6	165.55	165.6	235.0
2019-12-30 04:00:00	DIA	ETF	286.46	286.46	286.35	286.35	4333.0
2019-12-30 06:00:00	DIA	ETF	286.08	286.08	286.08	286.08	100.0

> showing 50 of 11,929 rows — these rows as CSV

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