PREVIEW / etf_1hour / 2019-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-01.parquet
  size:    340 KB
  rows:    11,174

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-04-01 04:00:00	SPY	ETF	284.51	284.89	284.51	284.71	19889.0
2019-04-01 05:00:00	SPY	ETF	284.75	284.77	284.4	284.41	24817.0
2019-04-01 06:00:00	SPY	ETF	284.42	284.5	284.26	284.28	36385.0
2019-04-01 07:00:00	SPY	ETF	284.24	284.61	284.23	284.57	149242.0
2019-04-01 08:00:00	SPY	ETF	284.6	284.74	282.48	284.5	608457.0
2019-04-01 09:00:00	SPY	ETF	284.5	284.88	284.4	284.51	8590415.0
2019-04-01 10:00:00	SPY	ETF	284.52	285.15	284.52	284.855	8625663.0
2019-04-01 11:00:00	SPY	ETF	284.87	285.25	284.74	285.0736	8928169.0
2019-04-01 12:00:00	SPY	ETF	285.0699	285.38	284.8199	285.375	4671359.0
2019-04-01 13:00:00	SPY	ETF	285.375	285.56	285.16	285.5451	7303878.0
2019-04-01 14:00:00	SPY	ETF	285.54	285.81	285.48	285.62	7114778.0
2019-04-01 15:00:00	SPY	ETF	285.615	286.16	285.32	285.89	16836146.0
2019-04-01 16:00:00	SPY	ETF	285.89	286.0	285.49	285.87	11682214.0
2019-04-01 17:00:00	SPY	ETF	285.89	285.92	285.72	285.72	491866.0
2019-04-01 18:00:00	SPY	ETF	285.71	285.78	285.58	285.63	72406.0
2019-04-01 19:00:00	SPY	ETF	285.68	286.0	285.62	285.97	245355.0
2019-04-01 04:00:00	QQQ	ETF	181.56	181.79	181.54	181.65	30165.0
2019-04-01 05:00:00	QQQ	ETF	181.65	181.7	181.4	181.42	17227.0
2019-04-01 06:00:00	QQQ	ETF	181.39	181.47	181.3	181.3	14757.0
2019-04-01 07:00:00	QQQ	ETF	181.31	181.46	181.29	181.42	96513.0
2019-04-01 08:00:00	QQQ	ETF	181.42	181.56	181.17	181.32	265191.0
2019-04-01 09:00:00	QQQ	ETF	181.31	181.71	181.02	181.1925	4988538.0
2019-04-01 10:00:00	QQQ	ETF	181.21	181.54	180.77	181.26	3943672.0
2019-04-01 11:00:00	QQQ	ETF	181.27	181.74	181.2194	181.52	3214713.0
2019-04-01 12:00:00	QQQ	ETF	181.52	181.9	181.29	181.9	2420282.0
2019-04-01 13:00:00	QQQ	ETF	181.895	182.055	181.68	182.035	2641766.0
2019-04-01 14:00:00	QQQ	ETF	182.03	182.14	181.93	182.089	2469587.0
2019-04-01 15:00:00	QQQ	ETF	182.08	182.26	181.87	182.14	5881952.0
2019-04-01 16:00:00	QQQ	ETF	182.13	182.23	181.82	182.05	1201478.0
2019-04-01 17:00:00	QQQ	ETF	182.05	182.13	182.05	182.05	4773.0
2019-04-01 18:00:00	QQQ	ETF	182.01	182.04	181.91	181.99	16692.0
2019-04-01 19:00:00	QQQ	ETF	182.0	182.25	181.96	182.21	41892.0
2019-04-01 04:00:00	IWM	ETF	154.0	154.25	154.0	154.2	6172.0
2019-04-01 05:00:00	IWM	ETF	154.22	154.22	154.01	154.01	1363.0
2019-04-01 06:00:00	IWM	ETF	154.0	154.06	153.95	153.95	3635.0
2019-04-01 07:00:00	IWM	ETF	153.85	154.15	153.83	154.14	90496.0
2019-04-01 08:00:00	IWM	ETF	154.11	154.2	153.89	154.08	102542.0
2019-04-01 09:00:00	IWM	ETF	154.17	154.5699	153.76	154.19	3283882.0
2019-04-01 10:00:00	IWM	ETF	154.24	154.92	154.13	154.33	3896806.0
2019-04-01 11:00:00	IWM	ETF	154.34	154.53	153.72	154.07	2395897.0
2019-04-01 12:00:00	IWM	ETF	154.08	154.3	153.88	154.21	1178190.0
2019-04-01 13:00:00	IWM	ETF	154.22	154.5	154.05	154.38	1125699.0
2019-04-01 14:00:00	IWM	ETF	154.39	154.53	154.13	154.36	1612859.0
2019-04-01 15:00:00	IWM	ETF	154.37	154.82	154.24	154.76	3516163.0
2019-04-01 16:00:00	IWM	ETF	154.76	154.76	154.54	154.73	1489237.0
2019-04-01 17:00:00	IWM	ETF	154.63	154.69	154.61	154.61	3363.0
2019-04-01 18:00:00	IWM	ETF	154.61	154.61	154.5	154.52	14045.0
2019-04-01 19:00:00	IWM	ETF	154.57	154.76	154.52	154.76	12798.0
2019-04-01 04:00:00	DIA	ETF	261.1	261.25	261.1	261.15	3100.0
2019-04-01 05:00:00	DIA	ETF	261.16	261.16	261.16	261.16	1000.0

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

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