PREVIEW / etf_1hour / 2019-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-19.parquet
  size:    347 KB
  rows:    11,444

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-19 04:00:00	SPY	ETF	319.92	320.08	319.85	320.08	7200.0
2019-12-19 05:00:00	SPY	ETF	320.08	320.11	319.95	320.04	6263.0
2019-12-19 06:00:00	SPY	ETF	320.02	320.05	319.86	319.95	4826.0
2019-12-19 07:00:00	SPY	ETF	319.91	320.0	319.59	319.71	69148.0
2019-12-19 08:00:00	SPY	ETF	319.9099	319.97	319.43	319.6001	344835.0
2019-12-19 09:00:00	SPY	ETF	319.59	320.1	319.59	319.96	4172605.0
2019-12-19 10:00:00	SPY	ETF	319.95	320.25	319.82	320.13	9743446.0
2019-12-19 11:00:00	SPY	ETF	320.13	320.7	320.12	320.51	9678505.0
2019-12-19 12:00:00	SPY	ETF	320.5	320.78	320.48	320.54	6817624.0
2019-12-19 13:00:00	SPY	ETF	320.54	320.82	320.4553	320.79	8120785.0
2019-12-19 14:00:00	SPY	ETF	320.79	320.98	320.74	320.86	6517682.0
2019-12-19 15:00:00	SPY	ETF	320.85	320.96	320.42	320.91	19184750.0
2019-12-19 16:00:00	SPY	ETF	320.92	321.24	319.5246	321.17	15491686.0
2019-12-19 17:00:00	SPY	ETF	321.18	321.19	320.9	321.18	2799826.0
2019-12-19 18:00:00	SPY	ETF	321.19	321.2	321.08	321.19	77268.0
2019-12-19 19:00:00	SPY	ETF	321.19	321.22	321.06	321.14	61114.0
2019-12-19 04:00:00	QQQ	ETF	209.62	209.78	209.56	209.78	31067.0
2019-12-19 05:00:00	QQQ	ETF	209.77	209.78	209.65	209.77	30169.0
2019-12-19 06:00:00	QQQ	ETF	209.82	209.82	209.61	209.7	5600.0
2019-12-19 07:00:00	QQQ	ETF	209.68	209.72	209.41	209.49	83873.0
2019-12-19 08:00:00	QQQ	ETF	209.6499	209.68	209.2709	209.59	667678.0
2019-12-19 09:00:00	QQQ	ETF	209.58	210.055	209.54	209.92	1301202.0
2019-12-19 10:00:00	QQQ	ETF	209.9	210.14	209.77	210.02	1560941.0
2019-12-19 11:00:00	QQQ	ETF	210.02	210.55	210.01	210.48	1590841.0
2019-12-19 12:00:00	QQQ	ETF	210.46	210.59	210.35	210.41	917284.0
2019-12-19 13:00:00	QQQ	ETF	210.42	210.59	210.325	210.54	992675.0
2019-12-19 14:00:00	QQQ	ETF	210.54	210.75	210.51	210.68	892370.0
2019-12-19 15:00:00	QQQ	ETF	210.68	210.93	210.5	210.89	2907709.0
2019-12-19 16:00:00	QQQ	ETF	210.88	211.17	210.8	211.12	1458640.0
2019-12-19 17:00:00	QQQ	ETF	211.07	211.15	210.86	211.1	269987.0
2019-12-19 18:00:00	QQQ	ETF	211.13	211.14	211.05	211.11	11123.0
2019-12-19 19:00:00	QQQ	ETF	211.12	211.14	211.0	211.05	19973.0
2019-12-19 04:00:00	IWM	ETF	165.21	165.24	165.18	165.18	4500.0
2019-12-19 05:00:00	IWM	ETF	165.15	165.27	165.11	165.27	13300.0
2019-12-19 06:00:00	IWM	ETF	165.21	165.21	165.17	165.19	5800.0
2019-12-19 07:00:00	IWM	ETF	165.17	165.2	165.04	165.04	23505.0
2019-12-19 08:00:00	IWM	ETF	165.21	165.21	164.94	165.12	27143.0
2019-12-19 09:00:00	IWM	ETF	165.1	165.28	164.88	165.14	1308433.0
2019-12-19 10:00:00	IWM	ETF	165.15	165.4	164.94	165.25	1381090.0
2019-12-19 11:00:00	IWM	ETF	165.25	165.445	165.2	165.33	736787.0
2019-12-19 12:00:00	IWM	ETF	165.35	165.51	165.3	165.33	794160.0
2019-12-19 13:00:00	IWM	ETF	165.34	165.51	165.31	165.5035	889325.0
2019-12-19 14:00:00	IWM	ETF	165.505	165.555	165.47	165.5	808016.0
2019-12-19 15:00:00	IWM	ETF	165.5	165.7	165.4	165.66	2201197.0
2019-12-19 16:00:00	IWM	ETF	165.66	165.82	165.56	165.8	733272.0
2019-12-19 17:00:00	IWM	ETF	165.7	165.79	165.7	165.79	594.0
2019-12-19 18:00:00	IWM	ETF	165.75	165.75	165.7	165.75	1794.0
2019-12-19 19:00:00	IWM	ETF	165.75	165.79	165.72	165.76	10500.0
2019-12-19 04:00:00	DIA	ETF	283.5	283.5	283.5	283.5	400.0
2019-12-19 05:00:00	DIA	ETF	283.67	283.75	283.59	283.75	21500.0

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

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