PREVIEW / etf_30min / 2011-12-20

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-20.parquet
  size:    289 KB
  rows:    9,728

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-12-20 04:00:00	SPY	ETF	121.26	121.42	121.26	121.42	1200.0
2011-12-20 04:30:00	SPY	ETF	121.32	121.74	121.25	121.55	5590.0
2011-12-20 05:00:00	SPY	ETF	121.56	121.56	121.46	121.48	5439.0
2011-12-20 05:30:00	SPY	ETF	121.45	121.7	121.45	121.53	81030.0
2011-12-20 06:00:00	SPY	ETF	121.57	121.65	121.46	121.62	25700.0
2011-12-20 06:30:00	SPY	ETF	121.67	121.68	121.4	121.43	123280.0
2011-12-20 07:00:00	SPY	ETF	121.42	121.45	121.32	121.35	135059.0
2011-12-20 07:30:00	SPY	ETF	121.35	121.75	121.31	121.73	551424.0
2011-12-20 08:00:00	SPY	ETF	121.75	121.78	120.95	121.65	2483577.0
2011-12-20 08:30:00	SPY	ETF	121.66	122.05	121.57	121.92	1891267.0
2011-12-20 09:00:00	SPY	ETF	121.92	122.22	121.92	122.17	2901076.0
2011-12-20 09:30:00	SPY	ETF	122.18	123.17	122.1701	122.98	30159940.0
2011-12-20 10:00:00	SPY	ETF	122.99	123.33	122.85	123.3	15869132.0
2011-12-20 10:30:00	SPY	ETF	123.29	123.47	123.215	123.36	11644859.0
2011-12-20 11:00:00	SPY	ETF	123.35	123.6	123.34	123.45	9563038.0
2011-12-20 11:30:00	SPY	ETF	123.45	123.65	123.26	123.43	10383991.0
2011-12-20 12:00:00	SPY	ETF	123.4254	123.5	123.26	123.47	5832422.0
2011-12-20 12:30:00	SPY	ETF	123.47	123.58	123.395	123.55	7125556.0
2011-12-20 13:00:00	SPY	ETF	123.55	123.93	123.54	123.72	12579647.0
2011-12-20 13:30:00	SPY	ETF	123.73	123.75	120.3702	123.69	10313681.0
2011-12-20 14:00:00	SPY	ETF	123.695	123.74	123.56	123.72	6574806.0
2011-12-20 14:30:00	SPY	ETF	123.72	124.06	123.72	123.895	9176745.0
2011-12-20 15:00:00	SPY	ETF	123.9	124.07	123.84	123.971	10520056.0
2011-12-20 15:30:00	SPY	ETF	123.98	124.14	123.75	123.93	29594390.0
2011-12-20 16:00:00	SPY	ETF	123.92	124.17	120.3702	124.0	18817805.0
2011-12-20 16:30:00	SPY	ETF	124.02	124.19	120.3702	124.11	20387912.0
2011-12-20 17:00:00	SPY	ETF	124.12	124.13	120.3702	124.01	3326579.0
2011-12-20 17:30:00	SPY	ETF	124.03	124.09	123.96	123.98	51579.0
2011-12-20 18:00:00	SPY	ETF	123.97	124.06	123.88	124.03	638497.0
2011-12-20 18:30:00	SPY	ETF	124.03	124.07	124.03	124.04	23840.0
2011-12-20 19:00:00	SPY	ETF	124.04	124.1	124.0	124.0	59996.0
2011-12-20 19:30:00	SPY	ETF	124.0	124.05	123.97	124.05	127308.0
2011-12-20 04:00:00	QQQ	ETF	54.76	54.76	54.76	54.76	300.0
2011-12-20 05:30:00	QQQ	ETF	54.83	54.92	54.83	54.85	2400.0
2011-12-20 06:00:00	QQQ	ETF	54.88	54.88	54.83	54.83	300.0
2011-12-20 07:00:00	QQQ	ETF	54.77	54.8	54.72	54.77	31700.0
2011-12-20 07:30:00	QQQ	ETF	54.77	54.98	54.77	54.98	212325.0
2011-12-20 08:00:00	QQQ	ETF	54.97	55.0	54.68	54.88	1047036.0
2011-12-20 08:30:00	QQQ	ETF	54.9	55.02	54.86	54.99	227087.0
2011-12-20 09:00:00	QQQ	ETF	54.99	55.21	54.99	55.19	2156923.0
2011-12-20 09:30:00	QQQ	ETF	55.2	55.59	55.17	55.5	14828212.0
2011-12-20 10:00:00	QQQ	ETF	55.5	55.67	55.44	55.65	6775348.0
2011-12-20 10:30:00	QQQ	ETF	55.65	55.72	55.59	55.65	4808289.0
2011-12-20 11:00:00	QQQ	ETF	55.65	55.8	55.64	55.6882	2513337.0
2011-12-20 11:30:00	QQQ	ETF	55.69	55.89	55.61	55.82	5156071.0
2011-12-20 12:00:00	QQQ	ETF	55.81	55.82	55.75	55.8	2417072.0
2011-12-20 12:30:00	QQQ	ETF	55.8	55.82	55.76	55.81	1498634.0
2011-12-20 13:00:00	QQQ	ETF	55.8014	56.0	55.8014	55.9199	4480489.0
2011-12-20 13:30:00	QQQ	ETF	55.92	55.93	55.8601	55.87	1434742.0
2011-12-20 14:00:00	QQQ	ETF	55.87	55.88	55.81	55.8599	1428937.0

> showing 50 of 9,728 rows — these rows as CSV

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