PREVIEW / etf_30min / 2011-09-01

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-01.parquet
  size:    282 KB
  rows:    9,392

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-09-01 04:00:00	SPY	ETF	121.93	121.93	121.93	121.93	300.0
2011-09-01 04:30:00	SPY	ETF	121.99	122.03	121.79	121.85	83200.0
2011-09-01 05:00:00	SPY	ETF	121.76	121.76	121.45	121.45	7385.0
2011-09-01 05:30:00	SPY	ETF	121.52	121.75	121.52	121.73	7400.0
2011-09-01 06:00:00	SPY	ETF	121.78	121.81	121.57	121.71	14172.0
2011-09-01 06:30:00	SPY	ETF	121.65	121.88	121.64	121.64	5500.0
2011-09-01 07:00:00	SPY	ETF	121.71	121.97	121.71	121.97	181300.0
2011-09-01 07:30:00	SPY	ETF	121.97	122.09	121.87	121.95	144334.0
2011-09-01 08:00:00	SPY	ETF	121.9	122.22	121.8	122.09	860306.0
2011-09-01 08:30:00	SPY	ETF	122.09	122.43	121.98	122.37	2821972.0
2011-09-01 09:00:00	SPY	ETF	122.37	122.41	122.06	122.29	623188.0
2011-09-01 09:30:00	SPY	ETF	122.29	122.56	121.69	121.96	23495614.0
2011-09-01 10:00:00	SPY	ETF	121.93	123.4	121.78	122.63	47667711.0
2011-09-01 10:30:00	SPY	ETF	122.63	122.72	122.14	122.17	21080686.0
2011-09-01 11:00:00	SPY	ETF	122.18	122.4	121.84	122.35	17339583.0
2011-09-01 11:30:00	SPY	ETF	122.35	122.56	122.085	122.455	12615140.0
2011-09-01 12:00:00	SPY	ETF	122.46	122.48	122.01	122.44	8080053.0
2011-09-01 12:30:00	SPY	ETF	122.44	122.51	121.97	122.02	8228479.0
2011-09-01 13:00:00	SPY	ETF	122.0111	122.08	121.72	121.97	10398873.0
2011-09-01 13:30:00	SPY	ETF	121.97	122.0	121.2	121.29	17933745.0
2011-09-01 14:00:00	SPY	ETF	121.31	121.36	120.95	121.22	15748230.0
2011-09-01 14:30:00	SPY	ETF	121.22	121.56	121.17	121.2329	12344088.0
2011-09-01 15:00:00	SPY	ETF	121.23	121.48	120.92	121.22	14137637.0
2011-09-01 15:30:00	SPY	ETF	121.22	121.24	120.78	120.93	26578770.0
2011-09-01 16:00:00	SPY	ETF	120.94	122.3139	120.65	120.66	12685348.0
2011-09-01 16:30:00	SPY	ETF	120.66	120.7	120.46	120.62	524064.0
2011-09-01 17:00:00	SPY	ETF	120.63	120.8	120.59	120.73	339352.0
2011-09-01 17:30:00	SPY	ETF	120.73	120.8	120.73	120.73	38182.0
2011-09-01 18:00:00	SPY	ETF	120.73	120.96	120.69	120.75	251277.0
2011-09-01 18:30:00	SPY	ETF	120.75	120.78	120.66	120.7	25652.0
2011-09-01 19:00:00	SPY	ETF	120.66	120.75	120.61	120.61	19543.0
2011-09-01 19:30:00	SPY	ETF	120.61	120.63	120.49	120.55	69118.0
2011-09-01 05:00:00	QQQ	ETF	54.81	54.81	54.79	54.79	400.0
2011-09-01 05:30:00	QQQ	ETF	54.86	55.01	54.86	55.01	900.0
2011-09-01 06:00:00	QQQ	ETF	54.98	54.98	54.94	54.94	400.0
2011-09-01 06:30:00	QQQ	ETF	54.98	54.98	54.98	54.98	500.0
2011-09-01 07:00:00	QQQ	ETF	54.95	55.02	54.94	55.0	5120.0
2011-09-01 07:30:00	QQQ	ETF	55.0	55.06	55.0	55.0	11690.0
2011-09-01 08:00:00	QQQ	ETF	55.0	55.46	54.8	54.8	116727.0
2011-09-01 08:30:00	QQQ	ETF	55.07	55.22	55.01	55.21	1304530.0
2011-09-01 09:00:00	QQQ	ETF	55.2	55.26	55.18	55.22	217765.0
2011-09-01 09:30:00	QQQ	ETF	55.21	55.33	54.99	55.17	5795699.0
2011-09-01 10:00:00	QQQ	ETF	55.17	55.64	55.1	55.3	12348598.0
2011-09-01 10:30:00	QQQ	ETF	55.29	55.33	55.09	55.1	3510122.0
2011-09-01 11:00:00	QQQ	ETF	55.1	55.189	54.93	55.15	3229436.0
2011-09-01 11:30:00	QQQ	ETF	55.15	55.26	55.05	55.22	1596083.0
2011-09-01 12:00:00	QQQ	ETF	55.22	55.23	54.97	55.11	1604867.0
2011-09-01 12:30:00	QQQ	ETF	55.11	55.14	54.9	54.91	1174240.0
2011-09-01 13:00:00	QQQ	ETF	54.9	54.94	54.79	54.88	2749148.0
2011-09-01 13:30:00	QQQ	ETF	54.88	54.89	54.59	54.63	2639422.0

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

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