PREVIEW / etf_30min / 2013-02-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-19.parquet
  size:    307 KB
  rows:    10,578

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
2013-02-19 04:00:00	SPY	ETF	152.17	152.17	152.15	152.17	10200.0
2013-02-19 04:30:00	SPY	ETF	152.22	152.35	152.22	152.35	40200.0
2013-02-19 05:00:00	SPY	ETF	152.32	152.37	152.32	152.34	27034.0
2013-02-19 05:30:00	SPY	ETF	152.34	152.37	152.33	152.33	32500.0
2013-02-19 06:00:00	SPY	ETF	152.3	152.31	152.3	152.3	700.0
2013-02-19 06:30:00	SPY	ETF	152.31	152.31	152.25	152.27	9100.0
2013-02-19 07:00:00	SPY	ETF	152.26	152.49	152.26	152.46	187689.0
2013-02-19 07:30:00	SPY	ETF	152.46	152.47	152.33	152.34	191903.0
2013-02-19 08:00:00	SPY	ETF	152.34	152.47	152.32	152.44	294285.0
2013-02-19 08:30:00	SPY	ETF	152.45	152.46	152.37	152.41	257731.0
2013-02-19 09:00:00	SPY	ETF	152.42	152.44	152.31	152.37	638163.0
2013-02-19 09:30:00	SPY	ETF	152.37	152.87	152.36	152.82	16203720.0
2013-02-19 10:00:00	SPY	ETF	152.82	152.88	152.67	152.87	6206903.0
2013-02-19 10:30:00	SPY	ETF	152.8696	152.9	152.66	152.72	4859972.0
2013-02-19 11:00:00	SPY	ETF	152.72	152.97	152.66	152.9601	3399976.0
2013-02-19 11:30:00	SPY	ETF	152.97	153.02	152.82	152.975	3903830.0
2013-02-19 12:00:00	SPY	ETF	152.98	153.0	152.83	152.8881	3660356.0
2013-02-19 12:30:00	SPY	ETF	152.885	152.95	152.815	152.95	2410456.0
2013-02-19 13:00:00	SPY	ETF	152.945	152.98	152.91	152.92	1793565.0
2013-02-19 13:30:00	SPY	ETF	152.925	152.99	152.9	152.97	2599556.0
2013-02-19 14:00:00	SPY	ETF	152.97	153.18	152.96	153.125	5170335.0
2013-02-19 14:30:00	SPY	ETF	153.125	153.24	153.07	153.09	3072169.0
2013-02-19 15:00:00	SPY	ETF	153.09	153.19	153.07	153.09	8347407.0
2013-02-19 15:30:00	SPY	ETF	153.08	153.28	153.0	153.22	12949483.0
2013-02-19 16:00:00	SPY	ETF	153.22	153.2763	152.1629	153.22	9043817.0
2013-02-19 16:30:00	SPY	ETF	153.22	153.29	152.1629	153.25	6180644.0
2013-02-19 17:00:00	SPY	ETF	153.26	153.28	153.25	153.26	33246.0
2013-02-19 17:30:00	SPY	ETF	153.26	153.28	153.25	153.25	4614.0
2013-02-19 18:00:00	SPY	ETF	153.26	153.27	153.22	153.25	16715.0
2013-02-19 18:30:00	SPY	ETF	153.25	153.26	153.23	153.25	15638.0
2013-02-19 19:00:00	SPY	ETF	153.27	153.27	153.25	153.26	4790.0
2013-02-19 19:30:00	SPY	ETF	153.26	153.28	153.24	153.28	24783.0
2013-02-19 04:00:00	QQQ	ETF	67.75	67.81	67.75	67.81	10200.0
2013-02-19 04:30:00	QQQ	ETF	67.83	67.86	67.82	67.86	7500.0
2013-02-19 05:00:00	QQQ	ETF	67.83	67.83	67.83	67.83	500.0
2013-02-19 06:30:00	QQQ	ETF	67.8	67.8	67.8	67.8	300.0
2013-02-19 07:00:00	QQQ	ETF	67.79	67.88	67.79	67.88	4800.0
2013-02-19 07:30:00	QQQ	ETF	67.89	67.9	67.87	67.9	2550.0
2013-02-19 08:00:00	QQQ	ETF	67.89	67.93	67.89	67.92	22885.0
2013-02-19 08:30:00	QQQ	ETF	67.92	67.93	67.91	67.92	17717.0
2013-02-19 09:00:00	QQQ	ETF	67.92	67.92	67.87	67.9	76347.0
2013-02-19 09:30:00	QQQ	ETF	67.9	68.12	67.86	68.05	3703582.0
2013-02-19 10:00:00	QQQ	ETF	68.05	68.095	67.95	68.08	1662385.0
2013-02-19 10:30:00	QQQ	ETF	68.09	68.1	67.895	67.94	1554977.0
2013-02-19 11:00:00	QQQ	ETF	67.94	68.03	67.89	68.02	1242086.0
2013-02-19 11:30:00	QQQ	ETF	68.02	68.05	67.95	68.04	816334.0
2013-02-19 12:00:00	QQQ	ETF	68.05	68.05	67.9431	68.02	675517.0
2013-02-19 12:30:00	QQQ	ETF	68.01	68.04	67.97	68.04	462524.0
2013-02-19 13:00:00	QQQ	ETF	68.0475	68.07	68.01	68.02	561667.0
2013-02-19 13:30:00	QQQ	ETF	68.03	68.08	67.93	67.965	879013.0

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

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