PREVIEW / etf_30min / 2012-08-31

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-31.parquet
  size:    278 KB
  rows:    9,445

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-08-31 04:00:00	SPY	ETF	140.66	140.7	140.66	140.7	600.0
2012-08-31 05:00:00	SPY	ETF	140.73	140.75	140.73	140.75	2000.0
2012-08-31 05:30:00	SPY	ETF	140.83	140.9	140.83	140.85	1990.0
2012-08-31 06:00:00	SPY	ETF	140.83	141.0	140.83	141.0	61300.0
2012-08-31 06:30:00	SPY	ETF	140.99	141.25	140.99	141.15	156080.0
2012-08-31 07:00:00	SPY	ETF	141.16	141.26	141.14	141.16	180155.0
2012-08-31 07:30:00	SPY	ETF	141.19	141.32	141.17	141.22	191508.0
2012-08-31 08:00:00	SPY	ETF	141.2	141.39	140.86	141.32	516606.0
2012-08-31 08:30:00	SPY	ETF	141.32	141.85	141.31	141.54	1699482.0
2012-08-31 09:00:00	SPY	ETF	141.57	141.58	141.22	141.29	985362.0
2012-08-31 09:30:00	SPY	ETF	141.29	141.59	141.211	141.24	11930234.0
2012-08-31 10:00:00	SPY	ETF	141.24	141.44	140.36	141.17	30944335.0
2012-08-31 10:30:00	SPY	ETF	141.165	141.66	141.02	141.6	11201664.0
2012-08-31 11:00:00	SPY	ETF	141.6	141.82	141.52	141.52	9312363.0
2012-08-31 11:30:00	SPY	ETF	141.53	141.61	141.46	141.47	5490141.0
2012-08-31 12:00:00	SPY	ETF	141.47	141.52	140.85	140.97	9884178.0
2012-08-31 12:30:00	SPY	ETF	140.9632	141.14	140.84	141.1	5331744.0
2012-08-31 13:00:00	SPY	ETF	141.1	141.14	140.71	140.78	7403555.0
2012-08-31 13:30:00	SPY	ETF	140.79	141.13	140.77	141.02	4583904.0
2012-08-31 14:00:00	SPY	ETF	141.02	141.42	141.02	141.391	6535237.0
2012-08-31 14:30:00	SPY	ETF	141.4	141.45	141.23	141.2955	4240722.0
2012-08-31 15:00:00	SPY	ETF	141.3	141.3	140.95	141.04	5664633.0
2012-08-31 15:30:00	SPY	ETF	141.05	141.45	140.93	141.16	18327829.0
2012-08-31 16:00:00	SPY	ETF	141.14	141.51	140.4507	141.1	9764298.0
2012-08-31 16:30:00	SPY	ETF	141.08	141.153	140.97	140.97	4458877.0
2012-08-31 17:00:00	SPY	ETF	140.99	141.1	140.98	140.98	296714.0
2012-08-31 17:30:00	SPY	ETF	140.98	141.01	140.95	141.0	56809.0
2012-08-31 18:00:00	SPY	ETF	141.0	141.0	140.99	141.0	3374.0
2012-08-31 18:30:00	SPY	ETF	141.0	141.0	140.99	140.99	39486.0
2012-08-31 19:00:00	SPY	ETF	140.98	141.03	140.98	141.03	5087.0
2012-08-31 19:30:00	SPY	ETF	141.03	141.07	140.99	140.99	17861.0
2012-08-31 04:00:00	QQQ	ETF	67.79	67.85	67.79	67.85	300.0
2012-08-31 05:30:00	QQQ	ETF	67.91	67.91	67.91	67.91	200.0
2012-08-31 06:00:00	QQQ	ETF	67.95	68.0	67.95	68.0	6400.0
2012-08-31 06:30:00	QQQ	ETF	68.07	68.18	68.07	68.16	5400.0
2012-08-31 07:00:00	QQQ	ETF	68.17	68.2	68.13	68.13	22702.0
2012-08-31 07:30:00	QQQ	ETF	68.14	68.2	68.12	68.13	4300.0
2012-08-31 08:00:00	QQQ	ETF	68.14	68.22	68.13	68.2	120341.0
2012-08-31 08:30:00	QQQ	ETF	68.21	68.37	68.21	68.34	324074.0
2012-08-31 09:00:00	QQQ	ETF	68.35	68.35	68.17	68.2	562788.0
2012-08-31 09:30:00	QQQ	ETF	68.2	68.34	67.97	67.99	4913924.0
2012-08-31 10:00:00	QQQ	ETF	67.99	68.08	67.47	67.95	7565484.0
2012-08-31 10:30:00	QQQ	ETF	67.95	68.2599	67.86	68.25	2982138.0
2012-08-31 11:00:00	QQQ	ETF	68.25	68.45	68.24	68.26	3337580.0
2012-08-31 11:30:00	QQQ	ETF	68.26	68.3	68.16	68.16	2089809.0
2012-08-31 12:00:00	QQQ	ETF	68.17	68.21	67.91	68.0001	1996760.0
2012-08-31 12:30:00	QQQ	ETF	68.01	68.09	67.95	68.06	873529.0
2012-08-31 13:00:00	QQQ	ETF	68.06	68.071	67.85	67.88	1123437.0
2012-08-31 13:30:00	QQQ	ETF	67.88	68.06	67.87	68.02	509320.0
2012-08-31 14:00:00	QQQ	ETF	68.02	68.23	67.995	68.22	1141181.0

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

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