PREVIEW / etf_1hour / 2015-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-02.parquet
  size:    247 KB
  rows:    7,923

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
2015-10-02 04:00:00	SPY	ETF	192.65	193.13	192.65	193.08	16575.0
2015-10-02 05:00:00	SPY	ETF	192.9	193.14	192.86	193.14	12041.0
2015-10-02 06:00:00	SPY	ETF	193.16	193.33	193.04	193.15	35811.0
2015-10-02 07:00:00	SPY	ETF	193.2	193.31	192.99	193.26	297339.0
2015-10-02 08:00:00	SPY	ETF	193.27	193.61	189.92	190.29	7836606.0
2015-10-02 09:00:00	SPY	ETF	190.28	190.3	189.12	189.79	26043397.0
2015-10-02 10:00:00	SPY	ETF	189.79	191.0	189.17	190.94	25621983.0
2015-10-02 11:00:00	SPY	ETF	190.93	191.54	190.57	191.1533	19448141.0
2015-10-02 12:00:00	SPY	ETF	191.15	192.84	191.09	192.67	24409970.0
2015-10-02 13:00:00	SPY	ETF	192.68	193.41	192.48	192.71	21582868.0
2015-10-02 14:00:00	SPY	ETF	192.71	193.35	192.605	192.82	14892532.0
2015-10-02 15:00:00	SPY	ETF	192.81	194.98	192.77	194.98	40786709.0
2015-10-02 16:00:00	SPY	ETF	194.98	195.16	194.71	195.05	11109434.0
2015-10-02 17:00:00	SPY	ETF	195.07	195.33	194.98	195.33	1042254.0
2015-10-02 18:00:00	SPY	ETF	195.33	195.45	195.2	195.37	222381.0
2015-10-02 19:00:00	SPY	ETF	195.37	195.38	195.25	195.38	73978.0
2015-10-02 20:00:00	SPY	ETF	194.919	194.919	194.919	194.919	100000.0
2015-10-02 04:00:00	QQQ	ETF	102.67	102.82	102.67	102.82	14400.0
2015-10-02 05:00:00	QQQ	ETF	102.75	102.81	102.75	102.81	600.0
2015-10-02 06:00:00	QQQ	ETF	102.84	102.94	102.79	102.87	10870.0
2015-10-02 07:00:00	QQQ	ETF	102.89	102.89	102.78	102.89	26694.0
2015-10-02 08:00:00	QQQ	ETF	102.88	103.02	100.92	101.22	1029311.0
2015-10-02 09:00:00	QQQ	ETF	101.21	101.21	100.48	100.95	6512361.0
2015-10-02 10:00:00	QQQ	ETF	100.93	101.859	100.52	101.83	9079634.0
2015-10-02 11:00:00	QQQ	ETF	101.82	102.11	101.5	101.84	5100037.0
2015-10-02 12:00:00	QQQ	ETF	101.85	102.88	101.76	102.78	6841849.0
2015-10-02 13:00:00	QQQ	ETF	102.78	103.19	102.6	102.65	5378437.0
2015-10-02 14:00:00	QQQ	ETF	102.645	103.15	102.58	102.86	3350116.0
2015-10-02 15:00:00	QQQ	ETF	102.862	104.0	102.82	103.99	11263500.0
2015-10-02 16:00:00	QQQ	ETF	103.99	104.15	103.93	104.12	1331940.0
2015-10-02 17:00:00	QQQ	ETF	104.12	104.15	101.709	104.15	199800.0
2015-10-02 18:00:00	QQQ	ETF	104.13	104.17	104.07	104.07	15413.0
2015-10-02 19:00:00	QQQ	ETF	104.12	104.17	104.03	104.03	28760.0
2015-10-02 05:00:00	IWM	ETF	109.4	109.45	109.38	109.38	2144.0
2015-10-02 06:00:00	IWM	ETF	109.45	109.45	109.45	109.45	350.0
2015-10-02 07:00:00	IWM	ETF	109.5	109.53	109.36	109.53	4400.0
2015-10-02 08:00:00	IWM	ETF	109.5	109.63	107.89	108.12	471506.0
2015-10-02 09:00:00	IWM	ETF	108.11	108.11	107.22	107.5	6804398.0
2015-10-02 10:00:00	IWM	ETF	107.49	108.12	107.12	108.09	10783370.0
2015-10-02 11:00:00	IWM	ETF	108.08	108.39	107.75	108.21	5739306.0
2015-10-02 12:00:00	IWM	ETF	108.22	109.1	108.14	109.02	6661481.0
2015-10-02 13:00:00	IWM	ETF	109.02	109.3	108.71	108.89	4404685.0
2015-10-02 14:00:00	IWM	ETF	108.9	109.5111	108.84	109.18	4228651.0
2015-10-02 15:00:00	IWM	ETF	109.18	110.63	109.16	110.6	10816012.0
2015-10-02 16:00:00	IWM	ETF	110.62	111.04	107.661	110.96	1949431.0
2015-10-02 17:00:00	IWM	ETF	110.96	111.1	110.88	111.0	33022.0
2015-10-02 18:00:00	IWM	ETF	110.96	111.19	110.96	111.16	4695.0
2015-10-02 19:00:00	IWM	ETF	110.91	110.95	110.91	110.93	6847.0
2015-10-02 07:00:00	DIA	ETF	163.3	163.38	163.28	163.38	700.0
2015-10-02 08:00:00	DIA	ETF	163.31	163.5	160.72	160.89	33352.0

> showing 50 of 7,923 rows — these rows as CSV

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