PREVIEW / etf_1hour / 2011-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-29.parquet
  size:    182 KB
  rows:    5,569

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-06-29 04:00:00	SPY	ETF	129.98	130.31	129.98	130.2	3000.0
2011-06-29 05:00:00	SPY	ETF	130.07	130.4	130.07	130.4	11843.0
2011-06-29 06:00:00	SPY	ETF	130.25	130.7	130.16	130.56	220637.0
2011-06-29 07:00:00	SPY	ETF	130.63	130.88	130.45	130.48	1199580.0
2011-06-29 08:00:00	SPY	ETF	130.49	130.8	130.09	130.6	6740463.0
2011-06-29 09:00:00	SPY	ETF	130.59	130.86	129.91	130.1	41842000.0
2011-06-29 10:00:00	SPY	ETF	130.1	130.6	129.71	130.59	36645522.0
2011-06-29 11:00:00	SPY	ETF	130.57	130.77	130.49	130.68	23542515.0
2011-06-29 12:00:00	SPY	ETF	130.69	130.84	130.63	130.67	13323846.0
2011-06-29 13:00:00	SPY	ETF	130.67	130.93	130.56	130.61	18233713.0
2011-06-29 14:00:00	SPY	ETF	130.62	130.69	130.16	130.445	34067250.0
2011-06-29 15:00:00	SPY	ETF	130.45	130.89	130.39	130.74	47239047.0
2011-06-29 16:00:00	SPY	ETF	130.75	131.0	130.4365	130.82	14771464.0
2011-06-29 17:00:00	SPY	ETF	130.81	130.86	129.6321	130.84	3186105.0
2011-06-29 18:00:00	SPY	ETF	130.84	130.92	130.75	130.88	300758.0
2011-06-29 19:00:00	SPY	ETF	130.88	130.94	130.87	130.9	115730.0
2011-06-29 04:00:00	QQQ	ETF	56.24	56.24	56.24	56.24	676.0
2011-06-29 05:00:00	QQQ	ETF	56.22	56.33	56.22	56.33	1800.0
2011-06-29 06:00:00	QQQ	ETF	56.36	56.45	56.3	56.45	7180.0
2011-06-29 07:00:00	QQQ	ETF	56.45	56.53	56.35	56.35	153726.0
2011-06-29 08:00:00	QQQ	ETF	56.35	56.43	56.17	56.36	1307205.0
2011-06-29 09:00:00	QQQ	ETF	56.38	56.45	55.93	56.05	11744482.0
2011-06-29 10:00:00	QQQ	ETF	56.05	56.37	55.9	56.345	11443521.0
2011-06-29 11:00:00	QQQ	ETF	56.345	56.4	56.19	56.29	6747428.0
2011-06-29 12:00:00	QQQ	ETF	56.285	56.35	56.26	56.3	1970857.0
2011-06-29 13:00:00	QQQ	ETF	56.305	56.41	56.28	56.31	2151562.0
2011-06-29 14:00:00	QQQ	ETF	56.3034	56.32	56.0	56.17	10948661.0
2011-06-29 15:00:00	QQQ	ETF	56.165	56.35	56.13	56.3	11210719.0
2011-06-29 16:00:00	QQQ	ETF	56.3	56.38	56.2901	56.33	2231431.0
2011-06-29 17:00:00	QQQ	ETF	56.31	56.33	56.31	56.33	4316.0
2011-06-29 18:00:00	QQQ	ETF	56.33	56.38	56.33	56.37	11155.0
2011-06-29 19:00:00	QQQ	ETF	56.38	56.38	56.34	56.35	7441.0
2011-06-29 04:00:00	IWM	ETF	82.17	82.3	82.13	82.25	2389.0
2011-06-29 05:00:00	IWM	ETF	82.19	82.38	82.16	82.38	900.0
2011-06-29 06:00:00	IWM	ETF	82.26	82.63	82.26	82.61	22484.0
2011-06-29 07:00:00	IWM	ETF	82.61	82.68	82.46	82.48	214248.0
2011-06-29 08:00:00	IWM	ETF	82.51	82.56	82.15	82.51	1674492.0
2011-06-29 09:00:00	IWM	ETF	82.51	82.65	81.66	81.78	12929174.0
2011-06-29 10:00:00	IWM	ETF	81.78	82.19	81.44	82.16	10774330.0
2011-06-29 11:00:00	IWM	ETF	82.16	82.23	82.02	82.19	5835310.0
2011-06-29 12:00:00	IWM	ETF	82.2	82.34	82.15	82.21	3001583.0
2011-06-29 13:00:00	IWM	ETF	82.21	82.4	82.09	82.12	3993963.0
2011-06-29 14:00:00	IWM	ETF	82.12	82.205	81.72	81.95	9013475.0
2011-06-29 15:00:00	IWM	ETF	81.95	82.2	81.86	82.17	8942661.0
2011-06-29 16:00:00	IWM	ETF	82.16	82.35	82.12	82.21	3037921.0
2011-06-29 17:00:00	IWM	ETF	82.24	82.24	82.19	82.22	3450.0
2011-06-29 18:00:00	IWM	ETF	82.25	82.26	82.19	82.22	3900.0
2011-06-29 19:00:00	IWM	ETF	82.23	82.24	82.2	82.22	9650.0
2011-06-29 04:00:00	DIA	ETF	121.9	122.0	121.9	122.0	3400.0
2011-06-29 05:00:00	DIA	ETF	122.0	122.15	122.0	122.15	5500.0

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

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