PREVIEW / etf_30min / 2011-11-09

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-09.parquet
  size:    302 KB
  rows:    10,130

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-09 04:00:00	SPY	ETF	127.11	127.11	125.79	125.94	32786.0
2011-11-09 04:30:00	SPY	ETF	125.76	126.01	125.6	125.6	29429.0
2011-11-09 05:00:00	SPY	ETF	125.69	125.84	125.25	125.44	78903.0
2011-11-09 05:30:00	SPY	ETF	125.52	125.52	125.1	125.4	61695.0
2011-11-09 06:00:00	SPY	ETF	125.33	125.33	124.63	124.74	644229.0
2011-11-09 06:30:00	SPY	ETF	124.63	125.18	124.59	124.91	1200513.0
2011-11-09 07:00:00	SPY	ETF	124.98	125.36	124.82	125.05	2696488.0
2011-11-09 07:30:00	SPY	ETF	125.04	125.26	124.89	125.2	1422929.0
2011-11-09 08:00:00	SPY	ETF	125.0	125.67	124.6	124.72	7691620.0
2011-11-09 08:30:00	SPY	ETF	124.74	125.24	124.28	125.21	5036867.0
2011-11-09 09:00:00	SPY	ETF	125.21	125.22	124.8	124.9	6851834.0
2011-11-09 09:30:00	SPY	ETF	124.89	125.8	124.32	124.51	33876903.0
2011-11-09 10:00:00	SPY	ETF	124.52	124.97	124.35	124.39	21259063.0
2011-11-09 10:30:00	SPY	ETF	124.4	125.14	124.17	124.91	25204134.0
2011-11-09 11:00:00	SPY	ETF	124.93	125.39	124.77	125.19	14881800.0
2011-11-09 11:30:00	SPY	ETF	125.18	125.47	125.02	125.22	10427688.0
2011-11-09 12:00:00	SPY	ETF	125.23	125.3	124.74	124.82	10917134.0
2011-11-09 12:30:00	SPY	ETF	124.82	125.12	124.76	125.08	7949662.0
2011-11-09 13:00:00	SPY	ETF	125.07	125.21	124.47	124.61	12405868.0
2011-11-09 13:30:00	SPY	ETF	124.605	124.64	123.7	123.9	17094726.0
2011-11-09 14:00:00	SPY	ETF	123.9	123.9	122.86	123.26	37198961.0
2011-11-09 14:30:00	SPY	ETF	123.25	123.6	123.04	123.32	18392106.0
2011-11-09 15:00:00	SPY	ETF	123.33	123.91	123.26	123.61	21552623.0
2011-11-09 15:30:00	SPY	ETF	123.61	123.61	122.94	123.17	46647109.0
2011-11-09 16:00:00	SPY	ETF	123.17	127.8445	122.94	123.24	13830423.0
2011-11-09 16:30:00	SPY	ETF	123.2	124.1369	123.02	123.26	9450938.0
2011-11-09 17:00:00	SPY	ETF	123.25	127.8445	123.16	123.21	7290340.0
2011-11-09 17:30:00	SPY	ETF	123.15	123.2	123.07	123.17	70594.0
2011-11-09 18:00:00	SPY	ETF	123.19	123.23	122.83	122.92	511069.0
2011-11-09 18:30:00	SPY	ETF	122.95	122.99	122.86	122.86	60214.0
2011-11-09 19:00:00	SPY	ETF	122.87	122.87	122.57	122.61	264716.0
2011-11-09 19:30:00	SPY	ETF	122.66	122.95	122.61	122.95	193589.0
2011-11-09 04:00:00	QQQ	ETF	58.58	58.58	58.09	58.09	5300.0
2011-11-09 04:30:00	QQQ	ETF	58.04	58.1	57.99	57.99	2850.0
2011-11-09 05:00:00	QQQ	ETF	57.96	57.96	57.8	57.82	9400.0
2011-11-09 05:30:00	QQQ	ETF	57.67	57.79	57.67	57.79	4900.0
2011-11-09 06:00:00	QQQ	ETF	57.77	57.77	57.54	57.55	4900.0
2011-11-09 06:30:00	QQQ	ETF	57.57	57.79	57.52	57.72	60512.0
2011-11-09 07:00:00	QQQ	ETF	57.76	57.9	57.7	57.78	76467.0
2011-11-09 07:30:00	QQQ	ETF	57.75	57.87	57.7	57.87	141562.0
2011-11-09 08:00:00	QQQ	ETF	57.87	57.96	57.67	57.68	225024.0
2011-11-09 08:30:00	QQQ	ETF	57.71	57.91	57.59	57.91	427459.0
2011-11-09 09:00:00	QQQ	ETF	57.92	57.92	57.7	57.72	666293.0
2011-11-09 09:30:00	QQQ	ETF	57.72	57.765	57.328	57.41	8051505.0
2011-11-09 10:00:00	QQQ	ETF	57.4	57.54	57.34	57.36	3623566.0
2011-11-09 10:30:00	QQQ	ETF	57.37	57.6	57.2	57.5	4974719.0
2011-11-09 11:00:00	QQQ	ETF	57.5	57.79	57.47	57.71	3504182.0
2011-11-09 11:30:00	QQQ	ETF	57.71	57.83	57.64	57.72	1905906.0
2011-11-09 12:00:00	QQQ	ETF	57.724	57.7588	57.53	57.56	1596138.0
2011-11-09 12:30:00	QQQ	ETF	57.56	57.76	57.54	57.75	1335557.0

> showing 50 of 10,130 rows — these rows as CSV

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