PREVIEW / etf_1hour / 2011-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-24.parquet
  size:    179 KB
  rows:    5,455

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-03-24 04:00:00	SPY	ETF	129.45	129.84	129.45	129.83	3500.0
2011-03-24 05:00:00	SPY	ETF	129.81	130.33	129.76	130.16	16550.0
2011-03-24 06:00:00	SPY	ETF	130.15	130.35	130.12	130.34	134900.0
2011-03-24 07:00:00	SPY	ETF	130.3	130.5	130.18	130.49	1267112.0
2011-03-24 08:00:00	SPY	ETF	130.46	130.66	130.22	130.3	5250880.0
2011-03-24 09:00:00	SPY	ETF	130.3	130.46	129.81	129.9	25750369.0
2011-03-24 10:00:00	SPY	ETF	129.9	130.59	129.67	130.54	28944810.0
2011-03-24 11:00:00	SPY	ETF	130.54	130.7	130.48	130.63	16744191.0
2011-03-24 12:00:00	SPY	ETF	130.63	130.87	130.45	130.525	19185387.0
2011-03-24 13:00:00	SPY	ETF	130.53	130.72	130.43	130.6	11505238.0
2011-03-24 14:00:00	SPY	ETF	130.6	130.89	130.6	130.78	10450252.0
2011-03-24 15:00:00	SPY	ETF	130.775	131.09	130.72	130.9	27113905.0
2011-03-24 16:00:00	SPY	ETF	130.91	130.96	129.6825	130.95	9468686.0
2011-03-24 17:00:00	SPY	ETF	130.94	131.78	130.9	131.27	484585.0
2011-03-24 18:00:00	SPY	ETF	131.26	131.4	130.9	131.28	918172.0
2011-03-24 19:00:00	SPY	ETF	131.27	131.32	131.22	131.23	112914.0
2011-03-24 04:00:00	QQQ	ETF	55.75	55.78	55.74	55.78	1700.0
2011-03-24 05:00:00	QQQ	ETF	55.84	56.08	55.83	56.04	20200.0
2011-03-24 06:00:00	QQQ	ETF	56.02	56.12	56.02	56.12	1200.0
2011-03-24 07:00:00	QQQ	ETF	56.04	56.13	56.02	56.08	56717.0
2011-03-24 08:00:00	QQQ	ETF	56.08	56.24	56.05	56.1	1873214.0
2011-03-24 09:00:00	QQQ	ETF	56.1	56.13	55.82	55.92	10228303.0
2011-03-24 10:00:00	QQQ	ETF	55.91	56.41	55.85	56.409	8194063.0
2011-03-24 11:00:00	QQQ	ETF	56.4	56.54	56.39	56.5	10711291.0
2011-03-24 12:00:00	QQQ	ETF	56.491	56.61	56.47	56.525	6502177.0
2011-03-24 13:00:00	QQQ	ETF	56.525	56.61	56.45	56.549	3407397.0
2011-03-24 14:00:00	QQQ	ETF	56.545	56.72	56.54	56.6605	6459063.0
2011-03-24 15:00:00	QQQ	ETF	56.67	56.82	56.635	56.71	11419632.0
2011-03-24 16:00:00	QQQ	ETF	56.7	56.76	56.53	56.67	2788498.0
2011-03-24 17:00:00	QQQ	ETF	56.67	58.52	56.66	56.85	314518.0
2011-03-24 18:00:00	QQQ	ETF	56.86	57.0	56.73	56.96	201644.0
2011-03-24 19:00:00	QQQ	ETF	56.95	56.96	56.89	56.89	43356.0
2011-03-24 04:00:00	IWM	ETF	80.78	80.97	80.77	80.97	3020.0
2011-03-24 05:00:00	IWM	ETF	81.05	81.29	81.05	81.29	6000.0
2011-03-24 06:00:00	IWM	ETF	81.33	81.38	81.27	81.37	62575.0
2011-03-24 07:00:00	IWM	ETF	81.34	81.52	81.33	81.5	43796.0
2011-03-24 08:00:00	IWM	ETF	81.48	81.63	81.27	81.34	339016.0
2011-03-24 09:00:00	IWM	ETF	81.33	81.56	80.94	81.04	4783750.0
2011-03-24 10:00:00	IWM	ETF	81.04	81.39	80.74	81.37	5545941.0
2011-03-24 11:00:00	IWM	ETF	81.36	81.52	81.35	81.5	4697465.0
2011-03-24 12:00:00	IWM	ETF	81.51	81.79	81.24	81.32	8575423.0
2011-03-24 13:00:00	IWM	ETF	81.32	81.44	81.19	81.42	3562445.0
2011-03-24 14:00:00	IWM	ETF	81.42	81.58	81.38	81.48	2969018.0
2011-03-24 15:00:00	IWM	ETF	81.49	81.76	81.42	81.54	8971376.0
2011-03-24 16:00:00	IWM	ETF	81.56	81.68	81.51	81.62	3105964.0
2011-03-24 17:00:00	IWM	ETF	81.63	81.85	81.63	81.72	58096.0
2011-03-24 18:00:00	IWM	ETF	81.75	81.82	81.72	81.74	8334.0
2011-03-24 19:00:00	IWM	ETF	81.79	81.8	81.71	81.8	5228.0
2011-03-24 05:00:00	DIA	ETF	120.74	121.07	120.74	121.06	3200.0
2011-03-24 07:00:00	DIA	ETF	121.09	121.27	121.0	121.27	6400.0

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

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