PREVIEW / etf_1hour / 2019-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-24.parquet
  size:    314 KB
  rows:    10,343

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-01-24 04:00:00	SPY	ETF	263.41	263.85	263.4	263.85	10296.0
2019-01-24 05:00:00	SPY	ETF	263.82	263.93	263.53	263.64	14344.0
2019-01-24 06:00:00	SPY	ETF	263.68	264.1	263.55	263.62	42643.0
2019-01-24 07:00:00	SPY	ETF	263.6	263.99	263.59	263.6	203661.0
2019-01-24 08:00:00	SPY	ETF	263.78	263.94	262.74	263.05	1359552.0
2019-01-24 09:00:00	SPY	ETF	263.0	263.56	262.47	262.94	6532345.0
2019-01-24 10:00:00	SPY	ETF	262.93	264.2	262.69	263.42	9861501.0
2019-01-24 11:00:00	SPY	ETF	263.41	264.0	262.72	263.8233	6932095.0
2019-01-24 12:00:00	SPY	ETF	263.8089	263.84	262.65	262.83	4385821.0
2019-01-24 13:00:00	SPY	ETF	262.82	262.925	262.08	262.76	6645430.0
2019-01-24 14:00:00	SPY	ETF	262.76	263.28	262.46	263.15	6457151.0
2019-01-24 15:00:00	SPY	ETF	263.14	263.76	263.04	263.62	9821775.0
2019-01-24 16:00:00	SPY	ETF	263.61	263.6564	262.83	263.2	4063040.0
2019-01-24 17:00:00	SPY	ETF	263.23	263.36	262.87	263.19	545079.0
2019-01-24 18:00:00	SPY	ETF	263.19	263.55	262.94	263.31	198457.0
2019-01-24 19:00:00	SPY	ETF	263.34	263.59	263.23	263.49	126672.0
2019-01-24 04:00:00	QQQ	ETF	162.53	162.97	162.47	162.97	24562.0
2019-01-24 05:00:00	QQQ	ETF	162.94	162.99	162.79	162.81	29408.0
2019-01-24 06:00:00	QQQ	ETF	162.84	163.13	162.8	162.87	41398.0
2019-01-24 07:00:00	QQQ	ETF	162.88	163.06	162.81	162.82	211670.0
2019-01-24 08:00:00	QQQ	ETF	162.85	163.07	162.28	162.37	471245.0
2019-01-24 09:00:00	QQQ	ETF	162.39	163.22	162.34	162.68	3974567.0
2019-01-24 10:00:00	QQQ	ETF	162.67	163.44	162.36	162.56	4961069.0
2019-01-24 11:00:00	QQQ	ETF	162.56	163.23	162.0626	163.17	3760934.0
2019-01-24 12:00:00	QQQ	ETF	163.16	163.18	162.4	162.56	1408005.0
2019-01-24 13:00:00	QQQ	ETF	162.55	162.65	162.08	162.58	2323055.0
2019-01-24 14:00:00	QQQ	ETF	162.57	162.95	162.401	162.8465	2104256.0
2019-01-24 15:00:00	QQQ	ETF	162.84	163.33	162.77	163.19	3459882.0
2019-01-24 16:00:00	QQQ	ETF	163.19	163.2246	162.17	162.61	1366207.0
2019-01-24 17:00:00	QQQ	ETF	162.63	162.63	162.5	162.57	37588.0
2019-01-24 18:00:00	QQQ	ETF	162.6	162.65	162.46	162.65	37079.0
2019-01-24 19:00:00	QQQ	ETF	162.68	162.89	162.67	162.8	40303.0
2019-01-24 04:00:00	IWM	ETF	144.79	144.94	144.79	144.94	3600.0
2019-01-24 05:00:00	IWM	ETF	144.83	144.83	144.74	144.74	2900.0
2019-01-24 06:00:00	IWM	ETF	144.78	144.79	144.78	144.79	1000.0
2019-01-24 07:00:00	IWM	ETF	144.79	144.88	144.79	144.85	8000.0
2019-01-24 08:00:00	IWM	ETF	144.67	144.83	144.34	144.47	172951.0
2019-01-24 09:00:00	IWM	ETF	144.45	144.96	144.33	144.91	1850527.0
2019-01-24 10:00:00	IWM	ETF	144.87	145.57	144.75	145.23	2324165.0
2019-01-24 11:00:00	IWM	ETF	145.23	145.75	144.81	145.7	2527895.0
2019-01-24 12:00:00	IWM	ETF	145.7	145.76	145.08	145.195	1532323.0
2019-01-24 13:00:00	IWM	ETF	145.2	145.27	144.72	145.17	1568027.0
2019-01-24 14:00:00	IWM	ETF	145.16	145.47	144.99	145.38	1158598.0
2019-01-24 15:00:00	IWM	ETF	145.37	145.64	145.3275	145.5	2174627.0
2019-01-24 16:00:00	IWM	ETF	145.5	145.5672	145.09	145.39	709016.0
2019-01-24 17:00:00	IWM	ETF	145.29	145.29	144.99	145.22	77427.0
2019-01-24 18:00:00	IWM	ETF	145.27	145.31	145.1	145.3	21097.0
2019-01-24 19:00:00	IWM	ETF	145.32	145.5	145.3	145.45	22220.0
2019-01-24 05:00:00	DIA	ETF	246.22	246.22	246.06	246.06	300.0
2019-01-24 07:00:00	DIA	ETF	246.12	246.29	246.0	246.0	3600.0

> showing 50 of 10,343 rows — these rows as CSV

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