PREVIEW / etf_1hour / 2011-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-17.parquet
  size:    175 KB
  rows:    5,394

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
2011-02-17 04:00:00	SPY	ETF	133.68	133.68	133.6	133.6	1300.0
2011-02-17 05:00:00	SPY	ETF	133.62	133.64	133.6	133.63	1200.0
2011-02-17 06:00:00	SPY	ETF	133.57	133.59	133.55	133.55	500.0
2011-02-17 07:00:00	SPY	ETF	133.55	133.74	133.55	133.73	92475.0
2011-02-17 08:00:00	SPY	ETF	133.73	133.85	133.29	133.36	2231832.0
2011-02-17 09:00:00	SPY	ETF	133.37	133.61	133.34	133.585	11316742.0
2011-02-17 10:00:00	SPY	ETF	133.5875	133.81	133.5	133.72	19545564.0
2011-02-17 11:00:00	SPY	ETF	133.72	134.14	133.69	134.08	16007506.0
2011-02-17 12:00:00	SPY	ETF	134.0717	134.11	133.96	134.02	7738076.0
2011-02-17 13:00:00	SPY	ETF	134.02	134.32	134.02	134.27	10870518.0
2011-02-17 14:00:00	SPY	ETF	134.27	134.39	134.18	134.31	11669777.0
2011-02-17 15:00:00	SPY	ETF	134.31	134.43	134.24	134.27	21316256.0
2011-02-17 16:00:00	SPY	ETF	134.27	134.3042	133.52	134.2	7406336.0
2011-02-17 17:00:00	SPY	ETF	134.2	134.2	134.08	134.12	173782.0
2011-02-17 18:00:00	SPY	ETF	134.11	134.22	134.1	134.17	41288.0
2011-02-17 19:00:00	SPY	ETF	134.19	134.19	134.11	134.18	13188.0
2011-02-17 07:00:00	QQQ	ETF	58.71	58.76	58.7	58.75	58841.0
2011-02-17 08:00:00	QQQ	ETF	58.76	58.77	58.59	58.63	1713350.0
2011-02-17 09:00:00	QQQ	ETF	58.62	58.77	58.55	58.75	6562112.0
2011-02-17 10:00:00	QQQ	ETF	58.76	58.86	58.66	58.7	6521926.0
2011-02-17 11:00:00	QQQ	ETF	58.6996	58.96	58.68	58.92	6161338.0
2011-02-17 12:00:00	QQQ	ETF	58.92	58.94	58.84	58.8501	1787209.0
2011-02-17 13:00:00	QQQ	ETF	58.85	58.97	58.85	58.91	2712036.0
2011-02-17 14:00:00	QQQ	ETF	58.91	58.975	58.86	58.9	3259845.0
2011-02-17 15:00:00	QQQ	ETF	58.9	58.94	58.82	58.87	4438801.0
2011-02-17 16:00:00	QQQ	ETF	58.861	58.9	58.79	58.81	1144322.0
2011-02-17 17:00:00	QQQ	ETF	58.83	58.83	58.77	58.81	28061.0
2011-02-17 18:00:00	QQQ	ETF	58.79	58.83	58.79	58.82	11239.0
2011-02-17 19:00:00	QQQ	ETF	58.81	58.81	58.79	58.8	17505.0
2011-02-17 04:00:00	IWM	ETF	82.55	82.55	82.55	82.55	280.0
2011-02-17 06:00:00	IWM	ETF	82.59	82.59	82.57	82.57	1000.0
2011-02-17 07:00:00	IWM	ETF	82.6	82.72	82.6	82.71	45600.0
2011-02-17 08:00:00	IWM	ETF	82.68	82.72	82.34	82.48	430739.0
2011-02-17 09:00:00	IWM	ETF	82.48	82.78	82.45	82.77	6310170.0
2011-02-17 10:00:00	IWM	ETF	82.77	82.89	82.59	82.73	5396229.0
2011-02-17 11:00:00	IWM	ETF	82.73	83.0601	82.71	83.0	3110711.0
2011-02-17 12:00:00	IWM	ETF	83.01	83.18	82.93	83.09	2799978.0
2011-02-17 13:00:00	IWM	ETF	83.09	83.32	83.085	83.2787	2184132.0
2011-02-17 14:00:00	IWM	ETF	83.28	83.39	83.21	83.31	2317352.0
2011-02-17 15:00:00	IWM	ETF	83.31	83.51	83.25	83.26	6327302.0
2011-02-17 16:00:00	IWM	ETF	83.26	83.43	82.6	83.28	1814688.0
2011-02-17 17:00:00	IWM	ETF	83.24	83.26	83.24	83.26	10000.0
2011-02-17 18:00:00	IWM	ETF	83.25	83.25	83.25	83.25	280.0
2011-02-17 19:00:00	IWM	ETF	83.25	83.28	83.25	83.25	7300.0
2011-02-17 07:00:00	DIA	ETF	122.76	122.76	122.72	122.76	1758.0
2011-02-17 08:00:00	DIA	ETF	122.77	122.77	122.49	122.55	11801.0
2011-02-17 09:00:00	DIA	ETF	122.57	122.72	122.56	122.63	439988.0
2011-02-17 10:00:00	DIA	ETF	122.65	122.9	122.61	122.83	961954.0
2011-02-17 11:00:00	DIA	ETF	122.84	123.05	122.79	122.99	796007.0
2011-02-17 12:00:00	DIA	ETF	122.98	123.04	122.9301	122.9301	321080.0

> showing 50 of 5,394 rows — these rows as CSV

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