PREVIEW / etf_30min / 2013-08-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-05.parquet
  size:    302 KB
  rows:    10,522

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-08-05 04:00:00	SPY	ETF	170.87	170.93	170.85	170.85	10850.0
2013-08-05 04:30:00	SPY	ETF	170.9	170.93	170.9	170.9	3700.0
2013-08-05 05:00:00	SPY	ETF	170.88	170.88	170.85	170.85	1200.0
2013-08-05 05:30:00	SPY	ETF	170.85	170.85	170.85	170.85	800.0
2013-08-05 06:00:00	SPY	ETF	170.85	170.85	170.85	170.85	100.0
2013-08-05 06:30:00	SPY	ETF	170.8	170.8	170.7	170.75	14100.0
2013-08-05 07:00:00	SPY	ETF	170.76	170.8	170.71	170.72	22835.0
2013-08-05 07:30:00	SPY	ETF	170.74	170.79	170.71	170.75	16300.0
2013-08-05 08:00:00	SPY	ETF	170.76	170.8	170.6	170.65	153718.0
2013-08-05 08:30:00	SPY	ETF	170.65	170.71	170.58	170.62	183543.0
2013-08-05 09:00:00	SPY	ETF	170.63	170.67	170.56	170.57	324616.0
2013-08-05 09:30:00	SPY	ETF	170.57	170.67	170.35	170.63	8627220.0
2013-08-05 10:00:00	SPY	ETF	170.64	170.78	170.58	170.7371	4771411.0
2013-08-05 10:30:00	SPY	ETF	170.73	170.96	170.73	170.85	4463511.0
2013-08-05 11:00:00	SPY	ETF	170.849	170.95	170.82	170.9	2582809.0
2013-08-05 11:30:00	SPY	ETF	170.9	170.9	170.68	170.7399	2250643.0
2013-08-05 12:00:00	SPY	ETF	170.735	170.86	170.72	170.79	1292688.0
2013-08-05 12:30:00	SPY	ETF	170.78	170.8	170.63	170.69	1903570.0
2013-08-05 13:00:00	SPY	ETF	170.69	170.7	170.44	170.62	3284566.0
2013-08-05 13:30:00	SPY	ETF	170.62	170.74	170.55	170.66	1737201.0
2013-08-05 14:00:00	SPY	ETF	170.66	170.7	170.54	170.63	2032993.0
2013-08-05 14:30:00	SPY	ETF	170.638	170.69	170.58	170.67	3374431.0
2013-08-05 15:00:00	SPY	ETF	170.67	170.8	170.59	170.77	2428370.0
2013-08-05 15:30:00	SPY	ETF	170.78	170.83	170.63	170.73	6956357.0
2013-08-05 16:00:00	SPY	ETF	170.74	170.9882	170.63	170.69	5410603.0
2013-08-05 16:30:00	SPY	ETF	170.7	170.71	170.64	170.69	127660.0
2013-08-05 17:00:00	SPY	ETF	170.68	170.69	170.59	170.6	274582.0
2013-08-05 17:30:00	SPY	ETF	170.6	170.62	170.57	170.57	117637.0
2013-08-05 18:00:00	SPY	ETF	170.59	170.59	170.45	170.45	137165.0
2013-08-05 18:30:00	SPY	ETF	170.46	170.46	170.4	170.46	48536.0
2013-08-05 19:00:00	SPY	ETF	170.46	170.49	170.44	170.46	18615.0
2013-08-05 19:30:00	SPY	ETF	170.45	170.5	170.45	170.48	13175.0
2013-08-05 04:00:00	QQQ	ETF	77.02	77.04	77.01	77.04	10100.0
2013-08-05 04:30:00	QQQ	ETF	77.05	77.05	77.03	77.03	2000.0
2013-08-05 05:00:00	QQQ	ETF	77.03	77.03	77.01	77.01	1200.0
2013-08-05 05:30:00	QQQ	ETF	77.01	77.01	77.01	77.01	700.0
2013-08-05 06:00:00	QQQ	ETF	77.02	77.02	77.01	77.01	600.0
2013-08-05 06:30:00	QQQ	ETF	77.03	77.03	76.97	76.98	2700.0
2013-08-05 07:00:00	QQQ	ETF	77.01	77.01	76.99	76.99	2400.0
2013-08-05 07:30:00	QQQ	ETF	76.98	77.0	76.98	77.0	3465.0
2013-08-05 08:00:00	QQQ	ETF	76.97	76.97	76.93	76.96	12500.0
2013-08-05 08:30:00	QQQ	ETF	76.96	76.96	76.91	76.91	34226.0
2013-08-05 09:00:00	QQQ	ETF	76.93	76.94	76.88	76.89	42779.0
2013-08-05 09:30:00	QQQ	ETF	76.89	76.95	76.815	76.92	1623697.0
2013-08-05 10:00:00	QQQ	ETF	76.93	76.98	76.9	76.95	1236704.0
2013-08-05 10:30:00	QQQ	ETF	76.95	77.08	76.95	77.03	1198834.0
2013-08-05 11:00:00	QQQ	ETF	77.03	77.06	76.99	77.02	744477.0
2013-08-05 11:30:00	QQQ	ETF	77.01	77.02	76.86	76.9001	1080713.0
2013-08-05 12:00:00	QQQ	ETF	76.91	76.979	76.9	76.9	579891.0
2013-08-05 12:30:00	QQQ	ETF	76.899	76.92	76.83	76.9	871218.0

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

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