PREVIEW / etf_30min / 2012-05-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-18.parquet
  size:    305 KB
  rows:    10,286

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-05-18 04:00:00	SPY	ETF	130.58	131.06	130.58	131.05	1650.0
2012-05-18 04:30:00	SPY	ETF	131.06	131.06	130.88	130.88	700.0
2012-05-18 05:00:00	SPY	ETF	130.93	130.93	130.62	130.76	2615.0
2012-05-18 05:30:00	SPY	ETF	130.98	131.3	130.95	131.27	39424.0
2012-05-18 06:00:00	SPY	ETF	131.21	131.29	131.13	131.29	14980.0
2012-05-18 06:30:00	SPY	ETF	131.21	131.35	131.15	131.21	40023.0
2012-05-18 07:00:00	SPY	ETF	131.23	131.55	131.23	131.46	517244.0
2012-05-18 07:30:00	SPY	ETF	131.46	131.48	131.21	131.29	674502.0
2012-05-18 08:00:00	SPY	ETF	131.27	131.41	131.09	131.25	1890755.0
2012-05-18 08:30:00	SPY	ETF	131.26	131.48	130.87	131.23	1357740.0
2012-05-18 09:00:00	SPY	ETF	131.23	131.43	131.15	131.37	1923339.0
2012-05-18 09:30:00	SPY	ETF	131.37	131.44	130.86	131.07	28527719.0
2012-05-18 10:00:00	SPY	ETF	131.07	131.23	130.88	131.1	18238258.0
2012-05-18 10:30:00	SPY	ETF	131.1	131.6	130.94	131.4	17527730.0
2012-05-18 11:00:00	SPY	ETF	131.405	131.475	130.94	130.96	16195456.0
2012-05-18 11:30:00	SPY	ETF	130.96	131.09	130.2	130.46	52337474.0
2012-05-18 12:00:00	SPY	ETF	130.46	130.95	130.46	130.9	32884064.0
2012-05-18 12:30:00	SPY	ETF	130.9	131.14	130.81	130.86	12223425.0
2012-05-18 13:00:00	SPY	ETF	130.86	131.0	130.67	130.745	10512619.0
2012-05-18 13:30:00	SPY	ETF	130.75	130.8327	130.335	130.3539	10085925.0
2012-05-18 14:00:00	SPY	ETF	130.36	130.46	130.0801	130.27	10113260.0
2012-05-18 14:30:00	SPY	ETF	130.27	130.28	129.84	130.03	15839634.0
2012-05-18 15:00:00	SPY	ETF	130.02	130.41	129.865	129.94	22317333.0
2012-05-18 15:30:00	SPY	ETF	129.945	130.002	129.55	129.82	33139418.0
2012-05-18 16:00:00	SPY	ETF	129.8	131.14	129.57	129.59	26712255.0
2012-05-18 16:30:00	SPY	ETF	129.61	129.8902	129.51	129.59	4605112.0
2012-05-18 17:00:00	SPY	ETF	129.58	129.67	129.5437	129.64	558074.0
2012-05-18 17:30:00	SPY	ETF	129.65	129.71	129.58	129.7	244734.0
2012-05-18 18:00:00	SPY	ETF	129.71	129.74	129.64	129.69	62117.0
2012-05-18 18:30:00	SPY	ETF	129.68	129.69	129.6	129.63	6926.0
2012-05-18 19:00:00	SPY	ETF	129.63	129.68	129.63	129.68	9246.0
2012-05-18 19:30:00	SPY	ETF	129.67	129.68	129.6	129.62	48931.0
2012-05-18 20:00:00	SPY	ETF	129.61	129.61	129.61	129.61	129.0
2012-05-18 04:00:00	QQQ	ETF	61.75	61.75	61.75	61.75	100.0
2012-05-18 05:00:00	QQQ	ETF	61.6	61.6	61.6	61.6	100.0
2012-05-18 05:30:00	QQQ	ETF	61.8	61.8	61.8	61.8	100.0
2012-05-18 06:00:00	QQQ	ETF	61.76	61.8	61.72	61.8	15005.0
2012-05-18 06:30:00	QQQ	ETF	61.8	61.88	61.8	61.8	6285.0
2012-05-18 07:00:00	QQQ	ETF	61.87	61.95	61.86	61.91	76020.0
2012-05-18 07:30:00	QQQ	ETF	61.92	61.93	61.79	61.81	100341.0
2012-05-18 08:00:00	QQQ	ETF	61.8	61.86	61.29	61.76	1173818.0
2012-05-18 08:30:00	QQQ	ETF	61.75	61.84	61.69	61.69	2403467.0
2012-05-18 09:00:00	QQQ	ETF	61.69	61.82	61.62	61.8	848915.0
2012-05-18 09:30:00	QQQ	ETF	61.8	61.86	61.39	61.52	7855736.0
2012-05-18 10:00:00	QQQ	ETF	61.52	61.79	61.43	61.77	6148506.0
2012-05-18 10:30:00	QQQ	ETF	61.76	61.96	61.68	61.8775	5270483.0
2012-05-18 11:00:00	QQQ	ETF	61.88	61.92	61.55	61.57	5016561.0
2012-05-18 11:30:00	QQQ	ETF	61.56	61.65	61.01	61.26	12895246.0
2012-05-18 12:00:00	QQQ	ETF	61.25	61.67	61.25	61.65	5349510.0
2012-05-18 12:30:00	QQQ	ETF	61.65	61.805	61.58	61.58	3856183.0

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

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