PREVIEW / etf_1hour / 2011-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-04.parquet
  size:    201 KB
  rows:    6,182

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-08-04 04:00:00	SPY	ETF	126.3	126.3	125.77	125.92	3700.0
2011-08-04 05:00:00	SPY	ETF	125.99	125.99	125.15	125.48	39360.0
2011-08-04 06:00:00	SPY	ETF	125.3	125.4	124.6	125.05	167530.0
2011-08-04 07:00:00	SPY	ETF	125.06	125.24	124.82	124.91	1902228.0
2011-08-04 08:00:00	SPY	ETF	124.93	125.38	124.12	124.88	12460567.0
2011-08-04 09:00:00	SPY	ETF	124.88	125.32	123.74	124.16	42343276.0
2011-08-04 10:00:00	SPY	ETF	124.16	124.37	123.03	123.19	66728972.0
2011-08-04 11:00:00	SPY	ETF	123.19	123.46	121.76	122.41	81747031.0
2011-08-04 12:00:00	SPY	ETF	122.42	123.33	122.25	122.86	46684248.0
2011-08-04 13:00:00	SPY	ETF	122.86	123.16	122.19	122.36	35408906.0
2011-08-04 14:00:00	SPY	ETF	122.37	122.86	121.35	122.01	64598892.0
2011-08-04 15:00:00	SPY	ETF	122.0	122.47	120.06	120.2	123518932.0
2011-08-04 16:00:00	SPY	ETF	120.2	126.4948	119.82	120.06	33877453.0
2011-08-04 17:00:00	SPY	ETF	120.08	120.37	120.05	120.26	3684647.0
2011-08-04 18:00:00	SPY	ETF	120.28	120.5	120.1	120.31	1297311.0
2011-08-04 19:00:00	SPY	ETF	120.23	120.23	119.97	120.06	277342.0
2011-08-04 04:00:00	QQQ	ETF	56.61	56.61	56.48	56.48	800.0
2011-08-04 05:00:00	QQQ	ETF	56.47	56.47	56.25	56.29	1600.0
2011-08-04 06:00:00	QQQ	ETF	56.34	56.35	56.06	56.2	89600.0
2011-08-04 07:00:00	QQQ	ETF	56.2	56.28	56.11	56.21	314880.0
2011-08-04 08:00:00	QQQ	ETF	56.2	56.36	55.86	56.19	2716806.0
2011-08-04 09:00:00	QQQ	ETF	56.18	56.36	55.69	55.87	13008728.0
2011-08-04 10:00:00	QQQ	ETF	55.86	56.01	55.33	55.39	21818508.0
2011-08-04 11:00:00	QQQ	ETF	55.39	55.55	54.83	55.0988	19215126.0
2011-08-04 12:00:00	QQQ	ETF	55.1	55.65	55.02	55.42	11256292.0
2011-08-04 13:00:00	QQQ	ETF	55.43	55.55	55.07	55.166	7354929.0
2011-08-04 14:00:00	QQQ	ETF	55.16	55.26	54.79	55.03	13930711.0
2011-08-04 15:00:00	QQQ	ETF	55.03	55.24	54.19	54.19	22437213.0
2011-08-04 16:00:00	QQQ	ETF	54.195	54.4	53.95	54.23	6094679.0
2011-08-04 17:00:00	QQQ	ETF	54.23	54.34	54.2	54.3	99178.0
2011-08-04 18:00:00	QQQ	ETF	54.3	54.32	54.18	54.29	165304.0
2011-08-04 19:00:00	QQQ	ETF	54.23	54.23	54.12	54.2	65199.0
2011-08-04 04:00:00	IWM	ETF	76.81	76.88	76.79	76.88	872.0
2011-08-04 05:00:00	IWM	ETF	76.69	76.69	76.45	76.45	707.0
2011-08-04 06:00:00	IWM	ETF	76.25	76.36	76.15	76.36	7900.0
2011-08-04 07:00:00	IWM	ETF	76.41	76.57	76.22	76.4	640316.0
2011-08-04 08:00:00	IWM	ETF	76.03	76.92	76.03	76.54	1925704.0
2011-08-04 09:00:00	IWM	ETF	76.52	76.85	75.48	75.91	9457234.0
2011-08-04 10:00:00	IWM	ETF	75.92	76.08	75.12	75.2	19817534.0
2011-08-04 11:00:00	IWM	ETF	75.19	75.49	74.43	74.83	21475085.0
2011-08-04 12:00:00	IWM	ETF	74.83	75.34	74.69	75.01	8809348.0
2011-08-04 13:00:00	IWM	ETF	75.01	75.16	74.45	74.53	6094534.0
2011-08-04 14:00:00	IWM	ETF	74.54	74.59	73.71	73.99	16989116.0
2011-08-04 15:00:00	IWM	ETF	73.99	74.32	72.59	72.65	28136886.0
2011-08-04 16:00:00	IWM	ETF	72.59	72.8271	72.43	72.48	5099762.0
2011-08-04 17:00:00	IWM	ETF	72.52	72.79	72.45	72.52	41649.0
2011-08-04 18:00:00	IWM	ETF	72.52	72.6	72.4	72.54	23316.0
2011-08-04 19:00:00	IWM	ETF	72.47	72.54	72.3	72.4	8500.0
2011-08-04 05:00:00	DIA	ETF	117.95	117.95	117.95	117.95	500.0
2011-08-04 06:00:00	DIA	ETF	117.9	117.9	117.9	117.9	500.0

> showing 50 of 6,182 rows — these rows as CSV

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