PREVIEW / etf_1hour / 2011-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-30.parquet
  size:    190 KB
  rows:    5,953

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-11-30 04:00:00	SPY	ETF	119.62	119.77	119.41	119.69	6500.0
2011-11-30 05:00:00	SPY	ETF	119.59	119.97	119.59	119.86	9882.0
2011-11-30 06:00:00	SPY	ETF	119.69	121.4	119.69	121.11	292861.0
2011-11-30 07:00:00	SPY	ETF	121.11	121.23	120.78	121.1	1333412.0
2011-11-30 08:00:00	SPY	ETF	120.85	124.0	119.5	123.79	21702581.0
2011-11-30 09:00:00	SPY	ETF	123.8	124.09	123.22	123.98	44426480.0
2011-11-30 10:00:00	SPY	ETF	123.98	124.5	123.73	124.48	41004902.0
2011-11-30 11:00:00	SPY	ETF	124.47	124.48	124.01	124.14	26430887.0
2011-11-30 12:00:00	SPY	ETF	124.14	124.24	124.0	124.14	17451615.0
2011-11-30 13:00:00	SPY	ETF	124.14	124.26	123.82	123.86	23912534.0
2011-11-30 14:00:00	SPY	ETF	123.86	124.18	123.8	124.06	30107198.0
2011-11-30 15:00:00	SPY	ETF	124.06	125.22	123.98	125.0897	66997649.0
2011-11-30 16:00:00	SPY	ETF	125.09	125.1705	124.0831	125.0	17698578.0
2011-11-30 17:00:00	SPY	ETF	125.0	125.12	124.98	125.04	21222756.0
2011-11-30 18:00:00	SPY	ETF	125.03	125.11	124.86	124.89	1170050.0
2011-11-30 19:00:00	SPY	ETF	124.89	124.93	124.74	124.84	913811.0
2011-11-30 04:00:00	QQQ	ETF	54.21	54.21	54.21	54.21	107.0
2011-11-30 05:00:00	QQQ	ETF	54.36	54.41	54.31	54.31	14380.0
2011-11-30 06:00:00	QQQ	ETF	54.6	54.94	54.6	54.9	108190.0
2011-11-30 07:00:00	QQQ	ETF	54.86	54.88	54.71	54.76	514018.0
2011-11-30 08:00:00	QQQ	ETF	54.73	55.92	54.72	55.91	4825512.0
2011-11-30 09:00:00	QQQ	ETF	55.92	55.99	55.67	55.93	9973810.0
2011-11-30 10:00:00	QQQ	ETF	55.93	56.32	55.87	56.31	12151337.0
2011-11-30 11:00:00	QQQ	ETF	56.31	56.315	56.12	56.1714	5614471.0
2011-11-30 12:00:00	QQQ	ETF	56.18	56.23	56.12	56.17	3546312.0
2011-11-30 13:00:00	QQQ	ETF	56.17	56.22	55.93	55.94	3774603.0
2011-11-30 14:00:00	QQQ	ETF	55.94	56.11	55.91	56.01	4625895.0
2011-11-30 15:00:00	QQQ	ETF	56.01	56.44	55.95	56.39	11725245.0
2011-11-30 16:00:00	QQQ	ETF	56.39	56.47	56.3108	56.45	2640396.0
2011-11-30 17:00:00	QQQ	ETF	56.42	56.48	56.41	56.41	42516.0
2011-11-30 18:00:00	QQQ	ETF	56.42	56.42	56.38	56.42	37225.0
2011-11-30 19:00:00	QQQ	ETF	56.41	56.42	56.36	56.39	29953.0
2011-11-30 06:00:00	IWM	ETF	70.09	70.81	70.09	70.65	11870.0
2011-11-30 07:00:00	IWM	ETF	70.7	70.7	70.4	70.62	552870.0
2011-11-30 08:00:00	IWM	ETF	70.58	72.59	70.54	72.47	3427340.0
2011-11-30 09:00:00	IWM	ETF	72.47	72.68	72.13	72.39	14945397.0
2011-11-30 10:00:00	IWM	ETF	72.42	72.75	72.33	72.74	10114273.0
2011-11-30 11:00:00	IWM	ETF	72.74	72.86	72.6299	72.71	7128276.0
2011-11-30 12:00:00	IWM	ETF	72.72	72.88	72.65	72.8	4936607.0
2011-11-30 13:00:00	IWM	ETF	72.8	72.85	72.64	72.73	4286332.0
2011-11-30 14:00:00	IWM	ETF	72.73	73.05	72.65	73.01	7264440.0
2011-11-30 15:00:00	IWM	ETF	73.02	73.79	72.89	73.76	18466666.0
2011-11-30 16:00:00	IWM	ETF	73.76	73.84	72.7	73.69	3455490.0
2011-11-30 17:00:00	IWM	ETF	73.75	73.81	73.73	73.75	109726.0
2011-11-30 18:00:00	IWM	ETF	73.73	73.77	73.69	73.71	9622.0
2011-11-30 19:00:00	IWM	ETF	73.71	73.72	73.61	73.64	8160.0
2011-11-30 06:00:00	DIA	ETF	116.3	116.3	116.3	116.3	200.0
2011-11-30 08:00:00	DIA	ETF	116.44	118.64	116.44	118.5	62890.0
2011-11-30 09:00:00	DIA	ETF	118.57	119.55	118.28	119.46	2240119.0
2011-11-30 10:00:00	DIA	ETF	119.47	119.89	119.26	119.87	2451414.0

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

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