PREVIEW / etf_30min / 2012-10-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-17.parquet
  size:    285 KB
  rows:    9,574

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
2012-10-17 04:00:00	SPY	ETF	145.27	145.48	145.27	145.48	2515.0
2012-10-17 04:30:00	SPY	ETF	145.49	145.49	145.47	145.47	20700.0
2012-10-17 05:00:00	SPY	ETF	145.45	145.53	145.45	145.53	700.0
2012-10-17 05:30:00	SPY	ETF	145.61	145.61	145.61	145.61	15000.0
2012-10-17 06:00:00	SPY	ETF	145.57	145.57	145.54	145.57	12000.0
2012-10-17 06:30:00	SPY	ETF	145.57	145.7	145.57	145.67	83628.0
2012-10-17 07:00:00	SPY	ETF	145.7	145.85	145.63	145.73	95885.0
2012-10-17 07:30:00	SPY	ETF	145.75	145.82	145.71	145.75	182655.0
2012-10-17 08:00:00	SPY	ETF	145.74	145.8	145.61	145.72	208270.0
2012-10-17 08:30:00	SPY	ETF	145.73	146.0	145.73	145.88	1356224.0
2012-10-17 09:00:00	SPY	ETF	145.86	145.89	145.62	145.63	881611.0
2012-10-17 09:30:00	SPY	ETF	145.64	145.95	145.42	145.88	14147967.0
2012-10-17 10:00:00	SPY	ETF	145.88	146.19	145.85	146.12	11554335.0
2012-10-17 10:30:00	SPY	ETF	146.12	146.22	146.01	146.055	8413603.0
2012-10-17 11:00:00	SPY	ETF	146.06	146.07	145.88	146.04	5349337.0
2012-10-17 11:30:00	SPY	ETF	146.04	146.16	145.98	146.11	3530321.0
2012-10-17 12:00:00	SPY	ETF	146.11	146.32	146.1	146.215	5534766.0
2012-10-17 12:30:00	SPY	ETF	146.21	146.25	146.17	146.195	2473840.0
2012-10-17 13:00:00	SPY	ETF	146.19	146.26	146.1	146.12	4704516.0
2012-10-17 13:30:00	SPY	ETF	146.12	146.16	145.7	145.86	7456153.0
2012-10-17 14:00:00	SPY	ETF	145.86	146.11	145.83	146.07	6045211.0
2012-10-17 14:30:00	SPY	ETF	146.08	146.19	146.03	146.16	6328520.0
2012-10-17 15:00:00	SPY	ETF	146.16	146.32	146.105	146.24	8751870.0
2012-10-17 15:30:00	SPY	ETF	146.25	146.32	146.1	146.19	14229020.0
2012-10-17 16:00:00	SPY	ETF	146.17	146.31	145.5801	146.23	13083988.0
2012-10-17 16:30:00	SPY	ETF	146.25	146.38	146.0	146.26	2677113.0
2012-10-17 17:00:00	SPY	ETF	146.26	146.31	146.22	146.27	164241.0
2012-10-17 17:30:00	SPY	ETF	146.29	146.3	146.25	146.25	34073.0
2012-10-17 18:00:00	SPY	ETF	146.25	146.25	146.21	146.22	11600.0
2012-10-17 18:30:00	SPY	ETF	146.22	146.22	146.19	146.19	42265.0
2012-10-17 19:00:00	SPY	ETF	146.21	146.22	146.18	146.21	10043.0
2012-10-17 19:30:00	SPY	ETF	146.23	146.24	146.18	146.22	12830.0
2012-10-17 05:30:00	QQQ	ETF	67.95	67.95	67.95	67.95	500.0
2012-10-17 06:00:00	QQQ	ETF	67.97	67.97	67.91	67.92	32150.0
2012-10-17 06:30:00	QQQ	ETF	67.96	67.98	67.92	67.95	184498.0
2012-10-17 07:00:00	QQQ	ETF	67.95	67.99	67.89	67.89	338200.0
2012-10-17 07:30:00	QQQ	ETF	67.88	67.9	67.83	67.84	199621.0
2012-10-17 08:00:00	QQQ	ETF	67.86	67.86	67.8	67.82	58443.0
2012-10-17 08:30:00	QQQ	ETF	67.88	67.9	67.82	67.87	350939.0
2012-10-17 09:00:00	QQQ	ETF	67.88	67.88	67.71	67.75	476749.0
2012-10-17 09:30:00	QQQ	ETF	67.76	68.12	67.68	68.075	6194159.0
2012-10-17 10:00:00	QQQ	ETF	68.08	68.29	68.05	68.15	6969307.0
2012-10-17 10:30:00	QQQ	ETF	68.15	68.185	68.06	68.12	2278883.0
2012-10-17 11:00:00	QQQ	ETF	68.12	68.14	68.03	68.12	1349592.0
2012-10-17 11:30:00	QQQ	ETF	68.1157	68.27	68.095	68.22	1416368.0
2012-10-17 12:00:00	QQQ	ETF	68.2101	68.3	68.205	68.24	1351288.0
2012-10-17 12:30:00	QQQ	ETF	68.245	68.27	68.22	68.23	494111.0
2012-10-17 13:00:00	QQQ	ETF	68.24	68.26	68.1462	68.15	1428984.0
2012-10-17 13:30:00	QQQ	ETF	68.16	68.165	67.915	67.95	2173664.0
2012-10-17 14:00:00	QQQ	ETF	67.95	68.07	67.93	68.05	966685.0

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

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