PREVIEW / etf_1hour / 2011-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-27.parquet
  size:    177 KB
  rows:    5,508

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-12-27 04:00:00	SPY	ETF	126.48	126.48	126.48	126.48	100.0
2011-12-27 05:00:00	SPY	ETF	126.5	126.5	126.5	126.5	100.0
2011-12-27 06:00:00	SPY	ETF	126.46	126.46	126.39	126.43	22000.0
2011-12-27 07:00:00	SPY	ETF	126.38	126.38	126.15	126.26	140519.0
2011-12-27 08:00:00	SPY	ETF	126.24	126.42	126.09	126.17	859329.0
2011-12-27 09:00:00	SPY	ETF	126.18	126.82	126.04	126.72	13300654.0
2011-12-27 10:00:00	SPY	ETF	126.72	126.82	126.34	126.399	15876996.0
2011-12-27 11:00:00	SPY	ETF	126.4	126.5709	126.36	126.54	6849028.0
2011-12-27 12:00:00	SPY	ETF	126.54	126.67	126.54	126.585	7900584.0
2011-12-27 13:00:00	SPY	ETF	126.59	126.75	126.5	126.72	5022199.0
2011-12-27 14:00:00	SPY	ETF	126.72	126.76	126.51	126.7	6866698.0
2011-12-27 15:00:00	SPY	ETF	126.7	126.75	126.41	126.46	14767408.0
2011-12-27 16:00:00	SPY	ETF	126.46	126.5867	126.35	126.39	8372045.0
2011-12-27 17:00:00	SPY	ETF	126.38	126.49	126.34	126.36	643468.0
2011-12-27 18:00:00	SPY	ETF	126.36	126.49	126.22	126.26	350862.0
2011-12-27 19:00:00	SPY	ETF	126.26	126.34	126.19	126.28	229946.0
2011-12-27 06:00:00	QQQ	ETF	56.06	56.06	56.05	56.05	800.0
2011-12-27 07:00:00	QQQ	ETF	56.04	56.04	55.92	55.96	10620.0
2011-12-27 08:00:00	QQQ	ETF	55.94	56.13	55.94	55.99	81728.0
2011-12-27 09:00:00	QQQ	ETF	55.98	56.3	55.93	56.24	4210970.0
2011-12-27 10:00:00	QQQ	ETF	56.24	56.34	56.095	56.12	4557791.0
2011-12-27 11:00:00	QQQ	ETF	56.12	56.24	56.11	56.23	1393028.0
2011-12-27 12:00:00	QQQ	ETF	56.225	56.32	56.225	56.29	1377989.0
2011-12-27 13:00:00	QQQ	ETF	56.29	56.4	56.26	56.385	1598054.0
2011-12-27 14:00:00	QQQ	ETF	56.385	56.42	56.31	56.38	1854212.0
2011-12-27 15:00:00	QQQ	ETF	56.38	56.39	56.19	56.22	4137472.0
2011-12-27 16:00:00	QQQ	ETF	56.22	56.265	56.07	56.11	1693779.0
2011-12-27 17:00:00	QQQ	ETF	56.11	56.13	56.11	56.12	4815.0
2011-12-27 18:00:00	QQQ	ETF	56.12	56.13	56.04	56.04	24773.0
2011-12-27 19:00:00	QQQ	ETF	56.09	56.1	56.06	56.1	23410.0
2011-12-27 07:00:00	IWM	ETF	74.35	74.35	74.23	74.29	9804.0
2011-12-27 08:00:00	IWM	ETF	74.32	74.45	74.24	74.3	63332.0
2011-12-27 09:00:00	IWM	ETF	74.3	74.55	74.08	74.48	3708833.0
2011-12-27 10:00:00	IWM	ETF	74.43	74.62	74.28	74.35	2873832.0
2011-12-27 11:00:00	IWM	ETF	74.34	74.68	74.315	74.67	1833061.0
2011-12-27 12:00:00	IWM	ETF	74.68	75.04	74.68	74.9	2205180.0
2011-12-27 13:00:00	IWM	ETF	74.9	75.155	74.84	75.12	1628676.0
2011-12-27 14:00:00	IWM	ETF	75.11	75.16	74.92	75.08	1829173.0
2011-12-27 15:00:00	IWM	ETF	75.075	75.145	74.74	74.78	4743177.0
2011-12-27 16:00:00	IWM	ETF	74.78	74.86	74.71	74.77	2666351.0
2011-12-27 17:00:00	IWM	ETF	74.74	74.77	74.7	74.7	2800.0
2011-12-27 18:00:00	IWM	ETF	74.72	74.72	74.68	74.68	3200.0
2011-12-27 19:00:00	IWM	ETF	74.69	74.69	74.67	74.67	1700.0
2011-12-27 08:00:00	DIA	ETF	122.5	122.5	122.35	122.35	2455.0
2011-12-27 09:00:00	DIA	ETF	122.35	122.98	122.33	122.94	698102.0
2011-12-27 10:00:00	DIA	ETF	122.95	123.0	122.5478	122.6171	826649.0
2011-12-27 11:00:00	DIA	ETF	122.61	122.8	122.56	122.76	286996.0
2011-12-27 12:00:00	DIA	ETF	122.77	122.9	122.77	122.799	360153.0
2011-12-27 13:00:00	DIA	ETF	122.79	122.94	122.7371	122.92	285162.0
2011-12-27 14:00:00	DIA	ETF	122.92	122.96	122.754	122.885	385634.0

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

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