PREVIEW / etf_30min / 2014-12-31

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-31.parquet
  size:    380 KB
  rows:    12,734

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
2014-12-31 04:00:00	SPY	ETF	208.09	208.3	208.09	208.18	1720.0
2014-12-31 04:30:00	SPY	ETF	208.22	208.23	208.22	208.23	5500.0
2014-12-31 05:00:00	SPY	ETF	208.16	208.16	208.16	208.16	100.0
2014-12-31 05:30:00	SPY	ETF	208.11	208.22	208.11	208.2	7300.0
2014-12-31 06:00:00	SPY	ETF	208.14	208.14	208.14	208.14	300.0
2014-12-31 06:30:00	SPY	ETF	208.11	208.11	208.05	208.05	2800.0
2014-12-31 07:00:00	SPY	ETF	208.06	208.14	208.06	208.12	6016.0
2014-12-31 07:30:00	SPY	ETF	208.11	208.17	208.11	208.15	8950.0
2014-12-31 08:00:00	SPY	ETF	208.14	208.23	208.01	208.06	112997.0
2014-12-31 08:30:00	SPY	ETF	208.1	208.17	208.07	208.11	43665.0
2014-12-31 09:00:00	SPY	ETF	208.11	208.14	207.97	207.99	408149.0
2014-12-31 09:30:00	SPY	ETF	207.99	208.09	207.71	207.8	7165328.0
2014-12-31 10:00:00	SPY	ETF	207.8	208.01	207.8	207.94	4694845.0
2014-12-31 10:30:00	SPY	ETF	207.945	208.19	207.94	208.1068	4163239.0
2014-12-31 11:00:00	SPY	ETF	208.1	208.14	207.82	207.82	6285051.0
2014-12-31 11:30:00	SPY	ETF	207.82	207.99	207.82	207.91	4503574.0
2014-12-31 12:00:00	SPY	ETF	207.92	207.94	206.96	207.23	8275461.0
2014-12-31 12:30:00	SPY	ETF	207.23	207.38	207.01	207.15	4619124.0
2014-12-31 13:00:00	SPY	ETF	207.1599	207.47	207.1	207.26	4691024.0
2014-12-31 13:30:00	SPY	ETF	207.25	207.44	207.0	207.15	4005688.0
2014-12-31 14:00:00	SPY	ETF	207.15	207.15	206.36	206.61	8607255.0
2014-12-31 14:30:00	SPY	ETF	206.61	206.7	206.1	206.33	9033560.0
2014-12-31 15:00:00	SPY	ETF	206.39	208.02	206.16	206.585	8650057.0
2014-12-31 15:30:00	SPY	ETF	206.58	206.65	205.39	205.52	28282008.0
2014-12-31 16:00:00	SPY	ETF	205.51	207.9	205.44	205.62	11467591.0
2014-12-31 16:30:00	SPY	ETF	205.62	205.73	205.47	205.57	1723010.0
2014-12-31 17:00:00	SPY	ETF	205.53	205.7	205.53	205.57	763773.0
2014-12-31 17:30:00	SPY	ETF	205.61	205.61	205.5	205.5	31335.0
2014-12-31 18:00:00	SPY	ETF	205.52	205.64	205.52	205.63	6562.0
2014-12-31 18:30:00	SPY	ETF	205.59	205.62	205.57	205.62	3471.0
2014-12-31 19:00:00	SPY	ETF	205.62	205.64	205.62	205.63	4469.0
2014-12-31 19:30:00	SPY	ETF	205.63	205.68	205.59	205.66	5925.0
2014-12-31 07:00:00	QQQ	ETF	104.45	104.46	104.45	104.46	200.0
2014-12-31 07:30:00	QQQ	ETF	104.49	104.49	104.48	104.48	738.0
2014-12-31 08:00:00	QQQ	ETF	104.49	104.65	104.49	104.49	24557.0
2014-12-31 08:30:00	QQQ	ETF	104.48	104.51	104.46	104.48	31128.0
2014-12-31 09:00:00	QQQ	ETF	104.5	104.55	104.45	104.49	77730.0
2014-12-31 09:30:00	QQQ	ETF	104.5	104.65	104.435	104.53	2628536.0
2014-12-31 10:00:00	QQQ	ETF	104.53	104.69	104.53	104.655	1176638.0
2014-12-31 10:30:00	QQQ	ETF	104.66	104.91	104.655	104.87	992236.0
2014-12-31 11:00:00	QQQ	ETF	104.876	104.89	104.61	104.62	850779.0
2014-12-31 11:30:00	QQQ	ETF	104.62	104.67	104.57	104.615	1066174.0
2014-12-31 12:00:00	QQQ	ETF	104.61	104.631	103.98	104.11	2052392.0
2014-12-31 12:30:00	QQQ	ETF	104.11	104.219	104.06	104.129	809685.0
2014-12-31 13:00:00	QQQ	ETF	104.13	104.28	104.06	104.14	644011.0
2014-12-31 13:30:00	QQQ	ETF	104.14	104.21	104.01	104.08	640505.0
2014-12-31 14:00:00	QQQ	ETF	104.08	104.085	103.57	103.73	2141815.0
2014-12-31 14:30:00	QQQ	ETF	103.735	103.82	103.47	103.5499	1443814.0
2014-12-31 15:00:00	QQQ	ETF	103.545	103.72	103.39	103.65	1790176.0
2014-12-31 15:30:00	QQQ	ETF	103.655	103.7	103.1	103.23	5422568.0

> showing 50 of 12,734 rows — these rows as CSV

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