PREVIEW / etf_1hour / 2019-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-23.parquet
  size:    352 KB
  rows:    11,631

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-23 04:00:00	SPY	ETF	321.34	321.46	321.33	321.4	7241.0
2019-12-23 05:00:00	SPY	ETF	321.37	321.5	321.37	321.41	11807.0
2019-12-23 06:00:00	SPY	ETF	321.47	321.66	321.47	321.56	24494.0
2019-12-23 07:00:00	SPY	ETF	321.62	321.98	321.58	321.8	91723.0
2019-12-23 08:00:00	SPY	ETF	321.65	321.92	321.22	321.65	224619.0
2019-12-23 09:00:00	SPY	ETF	321.65	321.7	321.215	321.31	5215942.0
2019-12-23 10:00:00	SPY	ETF	321.33	321.6	321.2486	321.575	6049393.0
2019-12-23 11:00:00	SPY	ETF	321.57	321.65	321.43	321.51	4870721.0
2019-12-23 12:00:00	SPY	ETF	321.5038	321.52	321.28	321.38	4180660.0
2019-12-23 13:00:00	SPY	ETF	321.375	321.515	321.31	321.38	3094860.0
2019-12-23 14:00:00	SPY	ETF	321.38	321.51	321.35	321.44	5793824.0
2019-12-23 15:00:00	SPY	ETF	321.435	321.46	321.06	321.22	10278894.0
2019-12-23 16:00:00	SPY	ETF	321.25	321.42	321.2	321.42	10973228.0
2019-12-23 17:00:00	SPY	ETF	321.36	321.42	321.36	321.41	851917.0
2019-12-23 18:00:00	SPY	ETF	321.44	321.55	321.34	321.45	24745.0
2019-12-23 19:00:00	SPY	ETF	321.46	321.46	321.31	321.35	9488.0
2019-12-23 04:00:00	QQQ	ETF	211.63	211.72	211.6	211.7	14347.0
2019-12-23 05:00:00	QQQ	ETF	211.73	211.79	211.69	211.72	6526.0
2019-12-23 06:00:00	QQQ	ETF	211.72	211.95	211.71	211.91	9050.0
2019-12-23 07:00:00	QQQ	ETF	211.93	212.24	211.89	212.08	57828.0
2019-12-23 08:00:00	QQQ	ETF	212.2	212.28	211.6	212.14	91622.0
2019-12-23 09:00:00	QQQ	ETF	212.15	212.17	211.79	211.87	2443035.0
2019-12-23 10:00:00	QQQ	ETF	211.88	212.03	211.74	212.02	1924302.0
2019-12-23 11:00:00	QQQ	ETF	212.02	212.15	211.95	212.125	1217932.0
2019-12-23 12:00:00	QQQ	ETF	212.12	212.14	211.91	211.93	1194147.0
2019-12-23 13:00:00	QQQ	ETF	211.94	212.03	211.885	211.9	893610.0
2019-12-23 14:00:00	QQQ	ETF	211.9	212.025	211.89	211.95	701142.0
2019-12-23 15:00:00	QQQ	ETF	211.95	211.97	211.63	211.75	2436356.0
2019-12-23 16:00:00	QQQ	ETF	211.76	211.95	211.75	211.92	1909893.0
2019-12-23 17:00:00	QQQ	ETF	211.87	211.99	211.81	211.91	167319.0
2019-12-23 18:00:00	QQQ	ETF	211.95	211.97	211.9	211.94	10461.0
2019-12-23 19:00:00	QQQ	ETF	211.9	211.91	211.78	211.81	20543.0
2019-12-23 04:00:00	IWM	ETF	166.04	166.04	166.02	166.02	5500.0
2019-12-23 05:00:00	IWM	ETF	166.04	166.05	166.04	166.05	300.0
2019-12-23 07:00:00	IWM	ETF	166.17	166.3	166.17	166.24	9273.0
2019-12-23 08:00:00	IWM	ETF	166.1599	166.29	165.97	166.16	41742.0
2019-12-23 09:00:00	IWM	ETF	166.14	166.33	165.36	165.66	1777251.0
2019-12-23 10:00:00	IWM	ETF	165.66	165.8	165.51	165.78	1244483.0
2019-12-23 11:00:00	IWM	ETF	165.79	166.1	165.79	166.07	1234506.0
2019-12-23 12:00:00	IWM	ETF	166.0799	166.14	165.99	166.08	662474.0
2019-12-23 13:00:00	IWM	ETF	166.08	166.24	166.075	166.2	644280.0
2019-12-23 14:00:00	IWM	ETF	166.2	166.36	166.195	166.32	612589.0
2019-12-23 15:00:00	IWM	ETF	166.32	166.34	166.09	166.32	2087530.0
2019-12-23 16:00:00	IWM	ETF	166.3	166.32	166.17	166.28	2804880.0
2019-12-23 17:00:00	IWM	ETF	166.34	166.34	166.34	166.34	203.0
2019-12-23 18:00:00	IWM	ETF	166.29	166.34	166.29	166.3	970.0
2019-12-23 19:00:00	IWM	ETF	166.3	166.3	166.28	166.3	5600.0
2019-12-23 05:00:00	DIA	ETF	284.84	284.91	284.84	284.91	200.0
2019-12-23 07:00:00	DIA	ETF	285.06	285.06	285.06	285.06	800.0
2019-12-23 08:00:00	DIA	ETF	285.2399	285.32	285.09	285.11	12452.0

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

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