PREVIEW / etf_1hour / 2011-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-16.parquet
  size:    185 KB
  rows:    5,700

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-16 04:00:00	SPY	ETF	125.76	126.22	125.62	126.19	55040.0
2011-11-16 05:00:00	SPY	ETF	126.27	126.34	124.93	124.99	241645.0
2011-11-16 06:00:00	SPY	ETF	125.12	125.12	124.49	124.84	315166.0
2011-11-16 07:00:00	SPY	ETF	124.87	125.48	124.65	125.09	1471149.0
2011-11-16 08:00:00	SPY	ETF	125.09	125.83	124.52	124.7	5067103.0
2011-11-16 09:00:00	SPY	ETF	124.7	125.39	124.46	125.21	25450202.0
2011-11-16 10:00:00	SPY	ETF	125.22	125.67	124.83	125.5989	29510873.0
2011-11-16 11:00:00	SPY	ETF	125.585	126.0	125.36	125.4	24974760.0
2011-11-16 12:00:00	SPY	ETF	125.41	126.1277	125.3	125.53	15239280.0
2011-11-16 13:00:00	SPY	ETF	125.53	126.34	125.51	126.04	19240530.0
2011-11-16 14:00:00	SPY	ETF	126.04	126.15	125.57	125.71	18968404.0
2011-11-16 15:00:00	SPY	ETF	125.72	125.78	123.9	124.09	73637218.0
2011-11-16 16:00:00	SPY	ETF	124.09	126.1277	123.42	123.62	15912624.0
2011-11-16 17:00:00	SPY	ETF	123.62	124.05	123.41	123.52	3520650.0
2011-11-16 18:00:00	SPY	ETF	123.54	124.05	123.34	123.55	556522.0
2011-11-16 19:00:00	SPY	ETF	123.53	123.73	123.3	123.41	452755.0
2011-11-16 04:00:00	QQQ	ETF	58.0	58.09	57.96	58.02	1400.0
2011-11-16 05:00:00	QQQ	ETF	58.22	58.22	57.82	57.82	1000.0
2011-11-16 06:00:00	QQQ	ETF	57.79	57.81	57.54	57.7	19100.0
2011-11-16 07:00:00	QQQ	ETF	57.67	57.97	57.59	57.79	118540.0
2011-11-16 08:00:00	QQQ	ETF	57.83	57.89	57.63	57.68	419678.0
2011-11-16 09:00:00	QQQ	ETF	57.67	57.94	57.55	57.84	9119235.0
2011-11-16 10:00:00	QQQ	ETF	57.84	58.0	57.59	57.95	8171257.0
2011-11-16 11:00:00	QQQ	ETF	57.95	58.07	57.73	57.75	5870418.0
2011-11-16 12:00:00	QQQ	ETF	57.75	57.92	57.7	57.8193	4042777.0
2011-11-16 13:00:00	QQQ	ETF	57.82	58.13	57.8	57.99	6344722.0
2011-11-16 14:00:00	QQQ	ETF	57.9999	58.03	57.8	57.87	5572068.0
2011-11-16 15:00:00	QQQ	ETF	57.86	57.91	57.06	57.15	18421365.0
2011-11-16 16:00:00	QQQ	ETF	57.15	57.17	56.76	56.86	2219735.0
2011-11-16 17:00:00	QQQ	ETF	56.85	56.88	56.8	56.88	33714.0
2011-11-16 18:00:00	QQQ	ETF	56.85	56.85	56.73	56.84	53008.0
2011-11-16 19:00:00	QQQ	ETF	56.84	56.9	56.76	56.79	64781.0
2011-11-16 04:00:00	IWM	ETF	73.96	73.96	73.96	73.96	399.0
2011-11-16 05:00:00	IWM	ETF	74.46	74.46	74.22	74.22	300.0
2011-11-16 06:00:00	IWM	ETF	73.55	73.55	73.34	73.4	10550.0
2011-11-16 07:00:00	IWM	ETF	73.4	73.85	73.4	73.58	163130.0
2011-11-16 08:00:00	IWM	ETF	73.58	73.71	73.31	73.4	413028.0
2011-11-16 09:00:00	IWM	ETF	73.39	74.24	73.11	73.75	8720926.0
2011-11-16 10:00:00	IWM	ETF	73.76	74.17	73.55	74.11	5753633.0
2011-11-16 11:00:00	IWM	ETF	74.13	74.48	74.0	74.06	4990446.0
2011-11-16 12:00:00	IWM	ETF	74.04	74.35	73.89	74.23	2748392.0
2011-11-16 13:00:00	IWM	ETF	74.23	74.88	74.21	74.59	5850821.0
2011-11-16 14:00:00	IWM	ETF	74.6	74.78	74.28	74.43	4770772.0
2011-11-16 15:00:00	IWM	ETF	74.43	74.52	72.91	73.07	16582336.0
2011-11-16 16:00:00	IWM	ETF	73.07	73.635	72.7	72.82	1266891.0
2011-11-16 17:00:00	IWM	ETF	72.85	73.06	72.73	72.81	33272.0
2011-11-16 18:00:00	IWM	ETF	72.79	72.89	72.75	72.87	13000.0
2011-11-16 19:00:00	IWM	ETF	72.87	72.92	72.7	72.75	36389.0
2011-11-16 08:00:00	DIA	ETF	120.0	120.15	119.75	119.77	68855.0
2011-11-16 09:00:00	DIA	ETF	119.72	120.1274	119.57	119.91	773455.0

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

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