PREVIEW / etf_1hour / 2011-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-22.parquet
  size:    174 KB
  rows:    5,359

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-22 04:00:00	SPY	ETF	129.69	130.0	129.69	130.0	2300.0
2011-03-22 05:00:00	SPY	ETF	130.27	130.35	129.81	129.81	2676.0
2011-03-22 06:00:00	SPY	ETF	129.73	129.82	129.51	129.59	55095.0
2011-03-22 07:00:00	SPY	ETF	129.59	129.81	129.53	129.73	288180.0
2011-03-22 08:00:00	SPY	ETF	129.72	129.9	129.57	129.67	1519847.0
2011-03-22 09:00:00	SPY	ETF	129.67	129.89	129.47	129.47	16277154.0
2011-03-22 10:00:00	SPY	ETF	129.47	129.83	129.25	129.25	22321632.0
2011-03-22 11:00:00	SPY	ETF	129.25	129.65	129.24	129.57	16402793.0
2011-03-22 12:00:00	SPY	ETF	129.5701	129.69	129.38	129.49	12469814.0
2011-03-22 13:00:00	SPY	ETF	129.5	129.565	129.25	129.49	10436119.0
2011-03-22 14:00:00	SPY	ETF	129.49	129.54	129.17	129.38	17895380.0
2011-03-22 15:00:00	SPY	ETF	129.375	129.5	129.26	129.3	20741621.0
2011-03-22 16:00:00	SPY	ETF	129.3	129.7658	129.19	129.27	8261740.0
2011-03-22 17:00:00	SPY	ETF	129.28	129.35	129.27	129.3	94400.0
2011-03-22 18:00:00	SPY	ETF	129.3	129.33	129.23	129.27	82775.0
2011-03-22 19:00:00	SPY	ETF	129.29	129.34	129.16	129.17	92878.0
2011-03-22 04:00:00	QQQ	ETF	55.5	55.53	55.5	55.53	2000.0
2011-03-22 05:00:00	QQQ	ETF	55.49	55.49	55.49	55.49	594.0
2011-03-22 06:00:00	QQQ	ETF	55.45	55.45	55.4	55.42	1800.0
2011-03-22 07:00:00	QQQ	ETF	55.41	55.51	55.38	55.47	126290.0
2011-03-22 08:00:00	QQQ	ETF	55.49	55.55	55.42	55.53	1329403.0
2011-03-22 09:00:00	QQQ	ETF	55.53	55.605	55.36	55.4	6281273.0
2011-03-22 10:00:00	QQQ	ETF	55.41	55.61	55.34	55.3402	4728441.0
2011-03-22 11:00:00	QQQ	ETF	55.35	55.4901	55.32	55.4726	3256694.0
2011-03-22 12:00:00	QQQ	ETF	55.475	55.55	55.4075	55.44	3127865.0
2011-03-22 13:00:00	QQQ	ETF	55.44	55.47	55.28	55.44	4055272.0
2011-03-22 14:00:00	QQQ	ETF	55.44	55.445	55.28	55.39	3828291.0
2011-03-22 15:00:00	QQQ	ETF	55.39	55.46	55.36	55.41	5790854.0
2011-03-22 16:00:00	QQQ	ETF	55.41	55.48	55.3628	55.44	1865854.0
2011-03-22 17:00:00	QQQ	ETF	55.44	55.48	55.43	55.43	206176.0
2011-03-22 18:00:00	QQQ	ETF	55.45	55.48	55.4	55.42	62456.0
2011-03-22 19:00:00	QQQ	ETF	55.42	55.49	55.38	55.47	49339.0
2011-03-22 04:00:00	IWM	ETF	81.44	81.45	81.4	81.4	1600.0
2011-03-22 05:00:00	IWM	ETF	81.58	81.58	81.58	81.58	1000.0
2011-03-22 06:00:00	IWM	ETF	81.48	81.48	81.42	81.42	2100.0
2011-03-22 07:00:00	IWM	ETF	81.41	81.48	81.33	81.41	26190.0
2011-03-22 08:00:00	IWM	ETF	81.39	81.48	81.31	81.38	169975.0
2011-03-22 09:00:00	IWM	ETF	81.39	81.6	81.21	81.22	6728101.0
2011-03-22 10:00:00	IWM	ETF	81.22	81.38	80.91	80.91	8771002.0
2011-03-22 11:00:00	IWM	ETF	80.92	81.05	80.87	80.98	5776099.0
2011-03-22 12:00:00	IWM	ETF	80.99	81.02	80.83	80.92	3619200.0
2011-03-22 13:00:00	IWM	ETF	80.9199	81.01	80.695	80.94	3086304.0
2011-03-22 14:00:00	IWM	ETF	80.94	80.97	80.67	80.91	4939371.0
2011-03-22 15:00:00	IWM	ETF	80.92	81.0399	80.8	80.9	6283144.0
2011-03-22 16:00:00	IWM	ETF	80.91	81.3032	80.72	80.83	2535469.0
2011-03-22 17:00:00	IWM	ETF	80.85	80.86	80.82	80.82	8000.0
2011-03-22 18:00:00	IWM	ETF	80.85	80.86	80.85	80.86	500.0
2011-03-22 19:00:00	IWM	ETF	80.82	80.82	80.77	80.77	5480.0
2011-03-22 06:00:00	DIA	ETF	120.05	120.05	120.05	120.05	200.0
2011-03-22 07:00:00	DIA	ETF	120.06	120.1	120.06	120.1	1500.0

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

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