PREVIEW / etf_1hour / 2011-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-12.parquet
  size:    181 KB
  rows:    5,647

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-12 04:00:00	SPY	ETF	126.02	126.02	125.14	125.29	10858.0
2011-12-12 05:00:00	SPY	ETF	125.15	125.54	125.15	125.25	17400.0
2011-12-12 06:00:00	SPY	ETF	125.34	125.66	125.34	125.55	394923.0
2011-12-12 07:00:00	SPY	ETF	125.44	125.63	125.38	125.45	741686.0
2011-12-12 08:00:00	SPY	ETF	125.5	125.52	125.09	125.19	2230630.0
2011-12-12 09:00:00	SPY	ETF	125.2	125.24	124.1	124.23	24346342.0
2011-12-12 10:00:00	SPY	ETF	124.23	124.59	123.8	124.04	27974421.0
2011-12-12 11:00:00	SPY	ETF	124.035	124.41	123.16	123.4265	29352236.0
2011-12-12 12:00:00	SPY	ETF	123.43	123.65	123.3	123.5	17606604.0
2011-12-12 13:00:00	SPY	ETF	123.5	124.22	123.29	123.59	15154233.0
2011-12-12 14:00:00	SPY	ETF	123.6	123.75	123.32	123.715	24161929.0
2011-12-12 15:00:00	SPY	ETF	123.71	124.3	123.46	124.19	48281980.0
2011-12-12 16:00:00	SPY	ETF	124.19	126.0453	124.05	124.08	17870836.0
2011-12-12 17:00:00	SPY	ETF	124.08	124.175	123.99	124.05	286522.0
2011-12-12 18:00:00	SPY	ETF	124.05	124.33	124.05	124.17	518744.0
2011-12-12 19:00:00	SPY	ETF	124.19	124.46	124.12	124.37	354130.0
2011-12-12 04:00:00	QQQ	ETF	56.71	56.71	56.57	56.57	1300.0
2011-12-12 05:00:00	QQQ	ETF	56.59	56.7	56.53	56.7	4720.0
2011-12-12 06:00:00	QQQ	ETF	56.68	56.81	56.67	56.81	15144.0
2011-12-12 07:00:00	QQQ	ETF	56.8	56.81	56.72	56.74	99514.0
2011-12-12 08:00:00	QQQ	ETF	56.78	56.78	56.61	56.67	430227.0
2011-12-12 09:00:00	QQQ	ETF	56.67	56.67	56.06	56.11	6707989.0
2011-12-12 10:00:00	QQQ	ETF	56.1101	56.21	55.95	56.14	5934503.0
2011-12-12 11:00:00	QQQ	ETF	56.145	56.29	55.9	56.015	6053954.0
2011-12-12 12:00:00	QQQ	ETF	56.01	56.16	55.96	56.0895	2470997.0
2011-12-12 13:00:00	QQQ	ETF	56.0816	56.185	56.0	56.15	2200340.0
2011-12-12 14:00:00	QQQ	ETF	56.15	56.21	56.02	56.16	6182076.0
2011-12-12 15:00:00	QQQ	ETF	56.17	56.42	56.05	56.39	11171476.0
2011-12-12 16:00:00	QQQ	ETF	56.39	56.47	56.33	56.39	1471759.0
2011-12-12 17:00:00	QQQ	ETF	56.38	56.41	56.37	56.39	92840.0
2011-12-12 18:00:00	QQQ	ETF	56.39	56.48	56.39	56.47	28255.0
2011-12-12 19:00:00	QQQ	ETF	56.43	56.54	56.41	56.52	24350.0
2011-12-12 06:00:00	IWM	ETF	74.1	74.15	74.1	74.15	5376.0
2011-12-12 07:00:00	IWM	ETF	74.14	74.15	74.0	74.01	6116.0
2011-12-12 08:00:00	IWM	ETF	73.84	74.15	73.73	73.77	87622.0
2011-12-12 09:00:00	IWM	ETF	73.82	73.82	72.85	72.97	6702923.0
2011-12-12 10:00:00	IWM	ETF	72.97	73.01	72.68	72.97	5774095.0
2011-12-12 11:00:00	IWM	ETF	72.96	73.11	72.56	72.74	5985353.0
2011-12-12 12:00:00	IWM	ETF	72.74	72.99	72.69	72.92	2588386.0
2011-12-12 13:00:00	IWM	ETF	72.92	72.98	72.78	72.9401	1767106.0
2011-12-12 14:00:00	IWM	ETF	72.94	72.95	72.5	72.8	6438063.0
2011-12-12 15:00:00	IWM	ETF	72.8	73.48	72.65	73.43	9414071.0
2011-12-12 16:00:00	IWM	ETF	73.43	73.57	73.3512	73.46	1691910.0
2011-12-12 17:00:00	IWM	ETF	73.47	73.48	73.43	73.47	26048.0
2011-12-12 18:00:00	IWM	ETF	73.48	73.55	73.48	73.53	17836.0
2011-12-12 19:00:00	IWM	ETF	73.53	73.61	73.52	73.58	13100.0
2011-12-12 05:00:00	DIA	ETF	121.55	121.55	121.55	121.55	1234.0
2011-12-12 06:00:00	DIA	ETF	121.42	121.45	121.38	121.38	8500.0
2011-12-12 07:00:00	DIA	ETF	121.35	121.36	121.35	121.36	1500.0
2011-12-12 08:00:00	DIA	ETF	121.27	121.27	121.0	121.05	12940.0

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

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