PREVIEW / etf_30min / 2012-08-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-27.parquet
  size:    275 KB
  rows:    9,289

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-27 04:00:00	SPY	ETF	141.75	141.84	141.75	141.84	400.0
2012-08-27 05:00:00	SPY	ETF	141.7	141.7	141.7	141.7	300.0
2012-08-27 05:30:00	SPY	ETF	141.72	141.72	141.7	141.7	200.0
2012-08-27 06:00:00	SPY	ETF	141.95	141.95	141.95	141.95	1000.0
2012-08-27 06:30:00	SPY	ETF	141.96	142.06	141.96	141.97	34165.0
2012-08-27 07:00:00	SPY	ETF	141.96	141.99	141.88	141.98	54580.0
2012-08-27 07:30:00	SPY	ETF	141.98	142.07	141.91	141.96	103520.0
2012-08-27 08:00:00	SPY	ETF	141.96	142.22	141.9	142.1	396307.0
2012-08-27 08:30:00	SPY	ETF	142.1	142.13	141.91	141.94	530975.0
2012-08-27 09:00:00	SPY	ETF	141.93	141.99	141.86	141.9	407704.0
2012-08-27 09:30:00	SPY	ETF	141.89	141.9	141.43	141.43	10691598.0
2012-08-27 10:00:00	SPY	ETF	141.43	141.6	141.37	141.53	5500250.0
2012-08-27 10:30:00	SPY	ETF	141.531	141.59	141.4	141.53	4748347.0
2012-08-27 11:00:00	SPY	ETF	141.53	142.0	141.5	141.98	5828604.0
2012-08-27 11:30:00	SPY	ETF	141.99	142.08	141.88	141.91	3417160.0
2012-08-27 12:00:00	SPY	ETF	141.9	142.01	141.81	141.85	2722655.0
2012-08-27 12:30:00	SPY	ETF	141.85	141.9	141.8	141.865	1649316.0
2012-08-27 13:00:00	SPY	ETF	141.865	141.97	141.82	141.93	1955371.0
2012-08-27 13:30:00	SPY	ETF	141.93	141.93	141.71	141.761	3680674.0
2012-08-27 14:00:00	SPY	ETF	141.77	141.81	141.64	141.79	2169091.0
2012-08-27 14:30:00	SPY	ETF	141.8	141.88	141.75	141.79	2823392.0
2012-08-27 15:00:00	SPY	ETF	141.794	141.82	141.54	141.62	4171086.0
2012-08-27 15:30:00	SPY	ETF	141.61	141.65	141.34	141.52	10484088.0
2012-08-27 16:00:00	SPY	ETF	141.53	141.54	141.44	141.49	3046692.0
2012-08-27 16:30:00	SPY	ETF	141.49	141.49	141.4	141.43	56983.0
2012-08-27 17:00:00	SPY	ETF	141.44	141.5	141.44	141.49	24165.0
2012-08-27 17:30:00	SPY	ETF	141.5	141.52	141.48	141.52	12106.0
2012-08-27 18:00:00	SPY	ETF	141.5	141.5	141.47	141.5	3222.0
2012-08-27 18:30:00	SPY	ETF	141.5	141.51	141.5	141.5	1095.0
2012-08-27 19:00:00	SPY	ETF	141.5	141.51	141.48	141.51	4169.0
2012-08-27 19:30:00	SPY	ETF	141.5	141.56	141.48	141.54	61024.0
2012-08-27 06:30:00	QQQ	ETF	68.58	68.58	68.54	68.56	800.0
2012-08-27 07:00:00	QQQ	ETF	68.58	68.59	68.52	68.56	19610.0
2012-08-27 07:30:00	QQQ	ETF	68.58	68.6	68.57	68.6	93800.0
2012-08-27 08:00:00	QQQ	ETF	68.6	68.7	68.58	68.67	115656.0
2012-08-27 08:30:00	QQQ	ETF	68.65	68.68	68.57	68.58	76307.0
2012-08-27 09:00:00	QQQ	ETF	68.58	68.63	68.57	68.6	154346.0
2012-08-27 09:30:00	QQQ	ETF	68.6	68.6	68.28	68.3	4116404.0
2012-08-27 10:00:00	QQQ	ETF	68.3	68.47	68.28	68.439	1778469.0
2012-08-27 10:30:00	QQQ	ETF	68.44	68.46	68.3	68.39	1455001.0
2012-08-27 11:00:00	QQQ	ETF	68.39	68.63	68.38	68.629	1894424.0
2012-08-27 11:30:00	QQQ	ETF	68.63	68.67	68.51	68.52	1196424.0
2012-08-27 12:00:00	QQQ	ETF	68.52	68.59	68.44	68.46	807808.0
2012-08-27 12:30:00	QQQ	ETF	68.46	68.5101	68.42	68.4801	762682.0
2012-08-27 13:00:00	QQQ	ETF	68.48	68.56	68.44	68.54	498701.0
2012-08-27 13:30:00	QQQ	ETF	68.53	68.54	68.41	68.4501	809566.0
2012-08-27 14:00:00	QQQ	ETF	68.45	68.49	68.38	68.48	616875.0
2012-08-27 14:30:00	QQQ	ETF	68.48	68.558	68.47	68.51	699257.0
2012-08-27 15:00:00	QQQ	ETF	68.5	68.51	68.32	68.37	1144802.0
2012-08-27 15:30:00	QQQ	ETF	68.37	68.39	68.25	68.39	2110864.0

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

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