PREVIEW / etf_30min / 2011-11-17

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-17.parquet
  size:    293 KB
  rows:    9,810

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-17 04:00:00	SPY	ETF	123.85	124.4	123.85	124.13	21425.0
2011-11-17 04:30:00	SPY	ETF	124.18	124.27	123.62	123.63	4500.0
2011-11-17 05:00:00	SPY	ETF	123.73	123.73	123.41	123.46	23470.0
2011-11-17 05:30:00	SPY	ETF	123.71	123.78	123.53	123.71	15600.0
2011-11-17 06:00:00	SPY	ETF	123.72	123.98	123.72	123.88	59925.0
2011-11-17 06:30:00	SPY	ETF	123.76	123.81	123.1	123.17	334914.0
2011-11-17 07:00:00	SPY	ETF	123.19	123.19	122.61	122.97	609239.0
2011-11-17 07:30:00	SPY	ETF	122.97	123.49	122.87	123.44	908185.0
2011-11-17 08:00:00	SPY	ETF	123.45	123.605	122.95	123.21	1788494.0
2011-11-17 08:30:00	SPY	ETF	123.25	123.95	123.25	123.66	3441189.0
2011-11-17 09:00:00	SPY	ETF	123.65	124.23	123.63	123.84	4603231.0
2011-11-17 09:30:00	SPY	ETF	123.85	123.96	122.97	123.48	26804868.0
2011-11-17 10:00:00	SPY	ETF	123.47	123.87	123.19	123.85	22290790.0
2011-11-17 10:30:00	SPY	ETF	123.86	124.16	123.44	123.765	24331695.0
2011-11-17 11:00:00	SPY	ETF	123.75	123.86	123.25	123.53	21385227.0
2011-11-17 11:30:00	SPY	ETF	123.53	123.9	123.44	123.5885	11189585.0
2011-11-17 12:00:00	SPY	ETF	123.58	123.67	122.92	122.94	11589609.0
2011-11-17 12:30:00	SPY	ETF	122.93	122.949	121.47	122.14	39426151.0
2011-11-17 13:00:00	SPY	ETF	122.14	122.28	121.66	122.02	17488334.0
2011-11-17 13:30:00	SPY	ETF	122.02	122.08	121.26	121.89	20449150.0
2011-11-17 14:00:00	SPY	ETF	121.89	121.91	121.29	121.59	15708877.0
2011-11-17 14:30:00	SPY	ETF	121.58	122.0	121.36	121.79	15954918.0
2011-11-17 15:00:00	SPY	ETF	121.79	122.03	121.37	121.65	20865276.0
2011-11-17 15:30:00	SPY	ETF	121.65	122.14	121.23	122.09	37569985.0
2011-11-17 16:00:00	SPY	ETF	122.17	124.0435	121.5	122.1	14247922.0
2011-11-17 16:30:00	SPY	ETF	122.1	122.23	122.09	122.14	17642751.0
2011-11-17 17:00:00	SPY	ETF	122.14	122.23	122.08	122.08	283817.0
2011-11-17 17:30:00	SPY	ETF	122.08	122.17	122.04	122.05	91150.0
2011-11-17 18:00:00	SPY	ETF	122.05	122.18	121.82	121.84	477675.0
2011-11-17 18:30:00	SPY	ETF	121.85	121.85	121.67	121.68	264808.0
2011-11-17 19:00:00	SPY	ETF	121.69	121.87	121.5	121.82	233885.0
2011-11-17 19:30:00	SPY	ETF	121.82	122.02	121.82	121.92	186339.0
2011-11-17 04:00:00	QQQ	ETF	57.07	57.19	57.07	57.19	1100.0
2011-11-17 04:30:00	QQQ	ETF	56.89	56.89	56.89	56.89	1600.0
2011-11-17 05:00:00	QQQ	ETF	56.9	56.9	56.86	56.86	20500.0
2011-11-17 05:30:00	QQQ	ETF	56.9	56.96	56.8	56.8	2100.0
2011-11-17 06:00:00	QQQ	ETF	56.93	57.01	56.93	57.01	1300.0
2011-11-17 06:30:00	QQQ	ETF	56.91	56.91	56.7	56.7	5500.0
2011-11-17 07:00:00	QQQ	ETF	56.68	56.68	56.54	56.61	16521.0
2011-11-17 07:30:00	QQQ	ETF	56.63	56.83	56.59	56.83	57100.0
2011-11-17 08:00:00	QQQ	ETF	56.81	56.81	56.65	56.81	231597.0
2011-11-17 08:30:00	QQQ	ETF	56.77	57.05	56.73	56.92	706144.0
2011-11-17 09:00:00	QQQ	ETF	56.93	57.13	56.91	57.02	808192.0
2011-11-17 09:30:00	QQQ	ETF	57.02	57.04	56.57	56.8	6396336.0
2011-11-17 10:00:00	QQQ	ETF	56.78	56.83	56.58	56.78	5640176.0
2011-11-17 10:30:00	QQQ	ETF	56.79	56.8777	56.6	56.61	5682258.0
2011-11-17 11:00:00	QQQ	ETF	56.6	56.66	56.32	56.5	8477776.0
2011-11-17 11:30:00	QQQ	ETF	56.49	56.65	56.42	56.4713	3141874.0
2011-11-17 12:00:00	QQQ	ETF	56.47	56.52	56.06	56.09	6940830.0
2011-11-17 12:30:00	QQQ	ETF	56.1	56.1	55.48	55.78	10932674.0

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

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