PREVIEW / etf_30min / 2013-08-14

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-14.parquet
  size:    311 KB
  rows:    10,625

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-14 04:00:00	SPY	ETF	169.51	169.51	169.07	169.14	14800.0
2013-08-14 04:30:00	SPY	ETF	169.12	169.22	169.04	169.2	12084.0
2013-08-14 05:00:00	SPY	ETF	169.18	169.22	169.1	169.12	3782.0
2013-08-14 05:30:00	SPY	ETF	169.14	169.24	169.12	169.23	3200.0
2013-08-14 06:00:00	SPY	ETF	169.23	169.32	169.23	169.24	2800.0
2013-08-14 06:30:00	SPY	ETF	169.26	169.38	169.26	169.38	31900.0
2013-08-14 07:00:00	SPY	ETF	169.4	169.4	169.29	169.34	44170.0
2013-08-14 07:30:00	SPY	ETF	169.35	169.39	169.34	169.36	54618.0
2013-08-14 08:00:00	SPY	ETF	169.28	169.37	169.06	169.14	283675.0
2013-08-14 08:30:00	SPY	ETF	169.14	169.32	169.1	169.32	283752.0
2013-08-14 09:00:00	SPY	ETF	169.32	169.57	169.32	169.54	772285.0
2013-08-14 09:30:00	SPY	ETF	169.53	169.8	169.34	169.58	9006788.0
2013-08-14 10:00:00	SPY	ETF	169.59	169.67	169.17	169.33	7008306.0
2013-08-14 10:30:00	SPY	ETF	169.33	169.46	168.86	169.06	6513056.0
2013-08-14 11:00:00	SPY	ETF	169.05	169.13	168.87	169.12	5475734.0
2013-08-14 11:30:00	SPY	ETF	169.12	169.22	168.86	168.98	4363063.0
2013-08-14 12:00:00	SPY	ETF	168.98	169.24	168.95	169.23	3859496.0
2013-08-14 12:30:00	SPY	ETF	169.23	169.27	169.01	169.02	2904484.0
2013-08-14 13:00:00	SPY	ETF	169.02	169.16	168.97	168.99	2593773.0
2013-08-14 13:30:00	SPY	ETF	168.98	168.98	168.7	168.9	8142306.0
2013-08-14 14:00:00	SPY	ETF	168.895	169.02	168.72	168.84	3378335.0
2013-08-14 14:30:00	SPY	ETF	168.84	169.04	168.79	168.95	3418704.0
2013-08-14 15:00:00	SPY	ETF	168.95	169.2	168.84	169.0	5156820.0
2013-08-14 15:30:00	SPY	ETF	169.0	169.01	168.71	168.74	9336214.0
2013-08-14 16:00:00	SPY	ETF	168.74	169.6442	168.6	168.64	4776241.0
2013-08-14 16:30:00	SPY	ETF	168.65	168.89	168.61	168.68	434027.0
2013-08-14 17:00:00	SPY	ETF	168.68	169.0764	168.55	168.55	300766.0
2013-08-14 17:30:00	SPY	ETF	168.58	168.58	168.48	168.52	196911.0
2013-08-14 18:00:00	SPY	ETF	168.52	168.52	168.21	168.33	173282.0
2013-08-14 18:30:00	SPY	ETF	168.37	168.4	168.31	168.34	48275.0
2013-08-14 19:00:00	SPY	ETF	168.33	168.35	168.3	168.32	10560.0
2013-08-14 19:30:00	SPY	ETF	168.34	168.37	168.28	168.3	26204.0
2013-08-14 04:00:00	QQQ	ETF	76.92	76.95	76.91	76.93	17000.0
2013-08-14 04:30:00	QQQ	ETF	76.95	76.97	76.95	76.97	2000.0
2013-08-14 05:00:00	QQQ	ETF	76.95	76.95	76.91	76.91	3500.0
2013-08-14 05:30:00	QQQ	ETF	76.93	77.0	76.93	77.0	4824.0
2013-08-14 06:00:00	QQQ	ETF	77.01	77.03	77.01	77.01	3200.0
2013-08-14 06:30:00	QQQ	ETF	77.01	77.07	77.01	77.07	3400.0
2013-08-14 07:00:00	QQQ	ETF	77.03	77.05	77.03	77.05	6452.0
2013-08-14 07:30:00	QQQ	ETF	77.04	77.05	77.02	77.04	22600.0
2013-08-14 08:00:00	QQQ	ETF	77.02	77.03	76.89	76.9	54974.0
2013-08-14 08:30:00	QQQ	ETF	76.91	77.01	76.91	77.0	20053.0
2013-08-14 09:00:00	QQQ	ETF	77.01	77.09	77.0	77.07	146010.0
2013-08-14 09:30:00	QQQ	ETF	77.07	77.18	76.93	77.099	4409899.0
2013-08-14 10:00:00	QQQ	ETF	77.11	77.1499	76.89	77.03	2136638.0
2013-08-14 10:30:00	QQQ	ETF	77.03	77.07	76.7	76.88	2321466.0
2013-08-14 11:00:00	QQQ	ETF	76.87	76.92	76.81	76.91	1276762.0
2013-08-14 11:30:00	QQQ	ETF	76.9	76.95	76.84	76.87	1037374.0
2013-08-14 12:00:00	QQQ	ETF	76.87	77.04	76.87	77.04	1151367.0
2013-08-14 12:30:00	QQQ	ETF	77.04	77.06	76.95	76.96	1554672.0

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

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