PREVIEW / etf_1hour / 2015-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-16.parquet
  size:    243 KB
  rows:    7,713

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-01-16 04:00:00	SPY	ETF	198.68	198.74	197.78	198.28	100515.0
2015-01-16 05:00:00	SPY	ETF	198.26	198.63	198.23	198.43	182683.0
2015-01-16 06:00:00	SPY	ETF	198.35	199.18	198.35	198.98	318274.0
2015-01-16 07:00:00	SPY	ETF	198.94	198.98	198.06	198.17	847848.0
2015-01-16 08:00:00	SPY	ETF	198.22	199.21	197.15	198.8	4313814.0
2015-01-16 09:00:00	SPY	ETF	198.84	199.86	198.61	198.97	20538684.0
2015-01-16 10:00:00	SPY	ETF	198.96	200.39	198.55	200.24	33121620.0
2015-01-16 11:00:00	SPY	ETF	200.24	200.48	199.7	199.88	16293871.0
2015-01-16 12:00:00	SPY	ETF	199.885	200.99	199.84	200.7	19230378.0
2015-01-16 13:00:00	SPY	ETF	200.695	200.78	200.1	200.75	37689138.0
2015-01-16 14:00:00	SPY	ETF	200.74	200.82	200.3201	200.7346	11451450.0
2015-01-16 15:00:00	SPY	ETF	200.73	201.82	200.5	201.55	38086626.0
2015-01-16 16:00:00	SPY	ETF	201.56	201.8	200.603	201.72	16193746.0
2015-01-16 17:00:00	SPY	ETF	201.72	201.83	201.67	201.72	2162501.0
2015-01-16 18:00:00	SPY	ETF	201.71	201.78	201.7	201.76	85707.0
2015-01-16 19:00:00	SPY	ETF	201.75	201.76	201.58	201.65	58735.0
2015-01-16 04:00:00	QQQ	ETF	99.04	99.04	99.04	99.04	1000.0
2015-01-16 05:00:00	QQQ	ETF	98.91	99.11	98.76	98.96	54050.0
2015-01-16 06:00:00	QQQ	ETF	98.99	99.3	98.98	99.3	15500.0
2015-01-16 07:00:00	QQQ	ETF	99.12	99.15	98.88	98.97	143529.0
2015-01-16 08:00:00	QQQ	ETF	98.98	99.57	98.98	99.39	388866.0
2015-01-16 09:00:00	QQQ	ETF	99.42	100.18	99.36	99.56	6565128.0
2015-01-16 10:00:00	QQQ	ETF	99.57	100.34	99.36	100.18	8612620.0
2015-01-16 11:00:00	QQQ	ETF	100.17	100.36	99.82	99.92	3830300.0
2015-01-16 12:00:00	QQQ	ETF	99.93	100.56	99.87	100.3599	2814851.0
2015-01-16 13:00:00	QQQ	ETF	100.36	100.42	100.05	100.39	1870173.0
2015-01-16 14:00:00	QQQ	ETF	100.39	100.46	100.22	100.43	1898679.0
2015-01-16 15:00:00	QQQ	ETF	100.43	100.95	100.31	100.83	6108930.0
2015-01-16 16:00:00	QQQ	ETF	100.83	100.96	100.79	100.95	826431.0
2015-01-16 17:00:00	QQQ	ETF	100.94	101.0	100.72	100.9	34498.0
2015-01-16 18:00:00	QQQ	ETF	100.85	100.89	100.85	100.89	2910.0
2015-01-16 19:00:00	QQQ	ETF	100.9	100.95	100.88	100.91	8758.0
2015-01-16 05:00:00	IWM	ETF	113.77	114.0	113.77	114.0	800.0
2015-01-16 06:00:00	IWM	ETF	114.36	114.36	114.36	114.36	200.0
2015-01-16 07:00:00	IWM	ETF	114.1	114.2	114.03	114.03	28080.0
2015-01-16 08:00:00	IWM	ETF	114.09	114.61	114.09	114.53	204747.0
2015-01-16 09:00:00	IWM	ETF	114.52	115.375	114.2	115.17	4888495.0
2015-01-16 10:00:00	IWM	ETF	115.17	115.94	114.84	115.77	8138825.0
2015-01-16 11:00:00	IWM	ETF	115.76	116.0101	115.47	115.93	3638103.0
2015-01-16 12:00:00	IWM	ETF	115.93	116.09	115.66	115.9047	3351930.0
2015-01-16 13:00:00	IWM	ETF	115.91	116.01	115.68	115.97	2180215.0
2015-01-16 14:00:00	IWM	ETF	115.97	115.99	115.79	115.93	1473107.0
2015-01-16 15:00:00	IWM	ETF	115.93	116.94	115.84	116.71	9193119.0
2015-01-16 16:00:00	IWM	ETF	116.7	116.85	116.52	116.71	1824437.0
2015-01-16 17:00:00	IWM	ETF	116.7	116.82	116.68	116.82	39600.0
2015-01-16 18:00:00	IWM	ETF	116.65	116.68	115.1882	116.56	104940.0
2015-01-16 19:00:00	IWM	ETF	116.57	116.57	116.57	116.57	1000.0
2015-01-16 06:00:00	DIA	ETF	172.65	173.06	172.65	173.06	16100.0
2015-01-16 07:00:00	DIA	ETF	172.6	172.6	172.6	172.6	5100.0
2015-01-16 08:00:00	DIA	ETF	172.27	172.9	172.25	172.6	5713.0

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

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