PREVIEW / etf_30min / 2016-02-05

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-05.parquet
  size:    392 KB
  rows:    13,197

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
2016-02-05 04:00:00	SPY	ETF	191.16	191.52	191.13	191.52	8020.0
2016-02-05 04:30:00	SPY	ETF	191.46	191.94	191.46	191.88	9055.0
2016-02-05 05:00:00	SPY	ETF	191.75	192.01	191.72	191.94	17650.0
2016-02-05 05:30:00	SPY	ETF	191.71	191.83	191.63	191.66	8115.0
2016-02-05 06:00:00	SPY	ETF	191.69	191.73	191.25	191.25	10776.0
2016-02-05 06:30:00	SPY	ETF	191.35	191.57	191.35	191.49	19250.0
2016-02-05 07:00:00	SPY	ETF	191.42	191.65	191.38	191.6	25120.0
2016-02-05 07:30:00	SPY	ETF	191.62	191.66	191.35	191.52	163543.0
2016-02-05 08:00:00	SPY	ETF	191.51	191.65	190.99	191.16	845344.0
2016-02-05 08:30:00	SPY	ETF	191.25	191.36	190.15	190.48	3064531.0
2016-02-05 09:00:00	SPY	ETF	190.48	191.62	190.43	190.99	1527611.0
2016-02-05 09:30:00	SPY	ETF	190.99	191.08	189.7	190.08	14747585.0
2016-02-05 10:00:00	SPY	ETF	190.09	190.58	189.09	189.24	12685568.0
2016-02-05 10:30:00	SPY	ETF	189.23	189.99	188.86	188.93	12482255.0
2016-02-05 11:00:00	SPY	ETF	188.96	189.15	187.9905	188.46	13111915.0
2016-02-05 11:30:00	SPY	ETF	188.4538	188.83	188.11	188.75	11716071.0
2016-02-05 12:00:00	SPY	ETF	188.75	191.6696	188.33	188.83	10059194.0
2016-02-05 12:30:00	SPY	ETF	188.83	189.21	188.28	188.5845	7133563.0
2016-02-05 13:00:00	SPY	ETF	188.58	188.98	188.46	188.92	5598125.0
2016-02-05 13:30:00	SPY	ETF	188.91	188.91	187.87	188.18	10737883.0
2016-02-05 14:00:00	SPY	ETF	188.18	188.36	187.45	187.605	10217407.0
2016-02-05 14:30:00	SPY	ETF	187.6	188.09	187.53	187.65	10642263.0
2016-02-05 15:00:00	SPY	ETF	187.66	188.05	187.2	187.84	15917170.0
2016-02-05 15:30:00	SPY	ETF	187.85	188.0	187.29	187.95	24965861.0
2016-02-05 16:00:00	SPY	ETF	187.94	188.31	187.77	188.17	11373490.0
2016-02-05 16:30:00	SPY	ETF	188.17	188.3579	187.9889	188.01	1069069.0
2016-02-05 17:00:00	SPY	ETF	188.06	188.06	187.87	187.87	116750.0
2016-02-05 17:30:00	SPY	ETF	187.87	187.95	187.72	187.74	1029618.0
2016-02-05 18:00:00	SPY	ETF	187.74	187.92	187.74	187.81	39488.0
2016-02-05 18:30:00	SPY	ETF	187.81	187.98	187.78	187.8	27160.0
2016-02-05 19:00:00	SPY	ETF	187.77	187.85	187.74	187.82	38999.0
2016-02-05 19:30:00	SPY	ETF	187.8	187.96	187.8	187.88	29957.0
2016-02-05 20:00:00	SPY	ETF	187.9893	187.9893	187.9893	187.9893	217500.0
2016-02-05 04:00:00	QQQ	ETF	101.48	101.54	101.48	101.54	500.0
2016-02-05 04:30:00	QQQ	ETF	101.69	101.82	101.69	101.82	260.0
2016-02-05 05:00:00	QQQ	ETF	101.75	101.75	101.72	101.74	700.0
2016-02-05 05:30:00	QQQ	ETF	101.77	101.77	101.69	101.74	1000.0
2016-02-05 06:00:00	QQQ	ETF	101.73	101.76	101.45	101.45	5600.0
2016-02-05 06:30:00	QQQ	ETF	101.51	101.68	101.45	101.58	15200.0
2016-02-05 07:00:00	QQQ	ETF	101.57	101.69	101.56	101.69	9900.0
2016-02-05 07:30:00	QQQ	ETF	101.69	101.71	101.51	101.6	16711.0
2016-02-05 08:00:00	QQQ	ETF	101.62	101.62	101.32	101.48	42090.0
2016-02-05 08:30:00	QQQ	ETF	101.43	101.46	100.52	101.0	882245.0
2016-02-05 09:00:00	QQQ	ETF	101.01	101.64	100.96	101.26	464885.0
2016-02-05 09:30:00	QQQ	ETF	101.29	101.33	100.04	100.15	6523296.0
2016-02-05 10:00:00	QQQ	ETF	100.16	100.43	99.44	99.51	5200693.0
2016-02-05 10:30:00	QQQ	ETF	99.515	99.92	99.19	99.23	4677510.0
2016-02-05 11:00:00	QQQ	ETF	99.24	99.35	98.4	98.71	4912983.0
2016-02-05 11:30:00	QQQ	ETF	98.72	98.97	98.48	98.925	4434470.0
2016-02-05 12:00:00	QQQ	ETF	98.92	99.12	98.64	98.88	2823343.0

> showing 50 of 13,197 rows — these rows as CSV

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