PREVIEW / etf_1hour / 2011-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-03.parquet
  size:    193 KB
  rows:    5,975

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-03 04:00:00	SPY	ETF	125.71	126.17	125.71	125.88	9112.0
2011-08-03 05:00:00	SPY	ETF	125.94	126.0	125.89	125.89	8800.0
2011-08-03 06:00:00	SPY	ETF	125.86	126.26	125.86	126.07	104520.0
2011-08-03 07:00:00	SPY	ETF	126.0	126.02	125.51	125.75	1466322.0
2011-08-03 08:00:00	SPY	ETF	125.76	126.0	125.12	125.87	5924936.0
2011-08-03 09:00:00	SPY	ETF	125.87	125.97	125.07	125.61	34357294.0
2011-08-03 10:00:00	SPY	ETF	125.61	125.91	123.53	124.65	92302083.0
2011-08-03 11:00:00	SPY	ETF	124.61	125.37	124.37	124.89	59141456.0
2011-08-03 12:00:00	SPY	ETF	124.89	124.93	124.19	124.74	29762212.0
2011-08-03 13:00:00	SPY	ETF	124.75	126.04	124.47	125.62	34642086.0
2011-08-03 14:00:00	SPY	ETF	125.62	125.92	125.0978	125.62	33356576.0
2011-08-03 15:00:00	SPY	ETF	125.63	126.31	125.39	126.2	60788367.0
2011-08-03 16:00:00	SPY	ETF	126.22	126.22	124.7471	126.0	15104593.0
2011-08-03 17:00:00	SPY	ETF	125.98	126.15	125.95	126.13	606733.0
2011-08-03 18:00:00	SPY	ETF	126.11	126.24	126.0	126.24	318069.0
2011-08-03 19:00:00	SPY	ETF	126.25	126.42	126.22	126.37	319070.0
2011-08-03 04:00:00	QQQ	ETF	56.43	56.43	56.43	56.43	200.0
2011-08-03 06:00:00	QQQ	ETF	56.44	56.57	56.44	56.51	5059.0
2011-08-03 07:00:00	QQQ	ETF	56.48	56.55	56.31	56.37	95350.0
2011-08-03 08:00:00	QQQ	ETF	56.36	56.64	56.26	56.44	914390.0
2011-08-03 09:00:00	QQQ	ETF	56.44	56.54	56.14	56.51	8653136.0
2011-08-03 10:00:00	QQQ	ETF	56.52	56.6	55.35	55.9505	26790479.0
2011-08-03 11:00:00	QQQ	ETF	55.96	56.44	55.85	56.2383	15230836.0
2011-08-03 12:00:00	QQQ	ETF	56.24	56.26	55.87	56.16	6540922.0
2011-08-03 13:00:00	QQQ	ETF	56.16	56.75	56.01	56.5801	11828088.0
2011-08-03 14:00:00	QQQ	ETF	56.5814	56.73	56.43	56.63	8013027.0
2011-08-03 15:00:00	QQQ	ETF	56.63	56.88	56.54	56.8	14060995.0
2011-08-03 16:00:00	QQQ	ETF	56.8	56.81	56.59	56.67	1533111.0
2011-08-03 17:00:00	QQQ	ETF	56.64	56.69	56.63	56.68	25210.0
2011-08-03 18:00:00	QQQ	ETF	56.68	56.77	56.65	56.75	88049.0
2011-08-03 19:00:00	QQQ	ETF	56.76	56.82	56.72	56.81	62174.0
2011-08-03 04:00:00	IWM	ETF	76.76	76.76	76.76	76.76	100.0
2011-08-03 05:00:00	IWM	ETF	76.83	76.83	76.71	76.75	4000.0
2011-08-03 06:00:00	IWM	ETF	76.69	76.96	76.69	76.8	30600.0
2011-08-03 07:00:00	IWM	ETF	76.7	76.81	76.46	76.63	116088.0
2011-08-03 08:00:00	IWM	ETF	76.64	76.95	76.4	76.85	845293.0
2011-08-03 09:00:00	IWM	ETF	76.83	76.95	76.27	76.62	8318141.0
2011-08-03 10:00:00	IWM	ETF	76.63	76.82	74.88	76.18	30914982.0
2011-08-03 11:00:00	IWM	ETF	76.18	76.76	75.97	76.53	15858968.0
2011-08-03 12:00:00	IWM	ETF	76.5112	76.55	75.79	76.211	7160425.0
2011-08-03 13:00:00	IWM	ETF	76.2	77.35	75.93	76.95	12336968.0
2011-08-03 14:00:00	IWM	ETF	76.95	77.17	76.55	76.89	5833468.0
2011-08-03 15:00:00	IWM	ETF	76.8879	77.28	76.63	77.27	17351011.0
2011-08-03 16:00:00	IWM	ETF	77.28	77.28	75.8	77.09	3484742.0
2011-08-03 17:00:00	IWM	ETF	77.04	77.15	77.02	77.15	4800.0
2011-08-03 18:00:00	IWM	ETF	77.14	77.2	77.09	77.13	4459.0
2011-08-03 19:00:00	IWM	ETF	77.2	77.25	77.19	77.24	8060.0
2011-08-03 05:00:00	DIA	ETF	118.92	118.92	118.92	118.92	100.0
2011-08-03 06:00:00	DIA	ETF	118.92	118.92	118.92	118.92	200.0
2011-08-03 07:00:00	DIA	ETF	118.8	118.9	118.65	118.65	19500.0

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

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