PREVIEW / etf_30min / 2016-01-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-15.parquet
  size:    429 KB
  rows:    14,514

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-01-15 04:00:00	SPY	ETF	190.99	190.99	188.93	189.2	49653.0
2016-01-15 04:30:00	SPY	ETF	189.25	189.5	188.87	188.9	13136.0
2016-01-15 05:00:00	SPY	ETF	189.15	189.39	188.81	188.89	42079.0
2016-01-15 05:30:00	SPY	ETF	188.86	188.9	188.33	188.59	51863.0
2016-01-15 06:00:00	SPY	ETF	188.5	189.06	188.22	188.66	78760.0
2016-01-15 06:30:00	SPY	ETF	188.63	189.17	188.63	188.94	116316.0
2016-01-15 07:00:00	SPY	ETF	188.93	189.37	188.84	188.84	395462.0
2016-01-15 07:30:00	SPY	ETF	188.89	189.15	188.65	189.05	571580.0
2016-01-15 08:00:00	SPY	ETF	188.65	191.54	188.45	188.58	1910198.0
2016-01-15 08:30:00	SPY	ETF	188.59	188.61	186.88	187.55	4621027.0
2016-01-15 09:00:00	SPY	ETF	187.56	187.69	186.62	186.79	4421671.0
2016-01-15 09:30:00	SPY	ETF	186.77	188.69	186.63	187.55	38691476.0
2016-01-15 10:00:00	SPY	ETF	187.56	188.57	186.99	188.11	27519119.0
2016-01-15 10:30:00	SPY	ETF	188.11	188.76	187.47	187.58	22593161.0
2016-01-15 11:00:00	SPY	ETF	187.58	187.825	187.07	187.703	20787612.0
2016-01-15 11:30:00	SPY	ETF	187.72	187.97	186.99	187.18	14342647.0
2016-01-15 12:00:00	SPY	ETF	187.18	187.35	185.98	186.23	23058831.0
2016-01-15 12:30:00	SPY	ETF	186.23	186.75	185.52	186.68	23539406.0
2016-01-15 13:00:00	SPY	ETF	186.68	187.15	186.24	186.69	15309701.0
2016-01-15 13:30:00	SPY	ETF	186.68	187.49	186.41	187.16	12760746.0
2016-01-15 14:00:00	SPY	ETF	187.16	187.46	186.6	186.6	14032633.0
2016-01-15 14:30:00	SPY	ETF	186.61	188.25	186.43	188.2089	17424706.0
2016-01-15 15:00:00	SPY	ETF	188.2	188.39	187.03	187.93	22450538.0
2016-01-15 15:30:00	SPY	ETF	187.915	188.18	187.4	187.78	33764906.0
2016-01-15 16:00:00	SPY	ETF	187.77	191.9752	187.75	188.12	16413825.0
2016-01-15 16:30:00	SPY	ETF	188.12	188.48	187.8235	188.23	3609521.0
2016-01-15 17:00:00	SPY	ETF	188.27	188.5	188.09	188.3	2456084.0
2016-01-15 17:30:00	SPY	ETF	188.32	188.35	188.11	188.33	50850.0
2016-01-15 18:00:00	SPY	ETF	188.3	188.55	187.83	188.53	326746.0
2016-01-15 18:30:00	SPY	ETF	188.53	188.54	187.81	188.31	460219.0
2016-01-15 19:00:00	SPY	ETF	188.35	188.35	188.15	188.18	28773.0
2016-01-15 19:30:00	SPY	ETF	188.2	188.3	188.14	188.26	33156.0
2016-01-15 04:00:00	QQQ	ETF	102.73	102.73	102.05	102.26	58719.0
2016-01-15 04:30:00	QQQ	ETF	102.21	102.35	102.03	102.17	20244.0
2016-01-15 05:00:00	QQQ	ETF	102.1	102.1	101.9	101.9	13500.0
2016-01-15 05:30:00	QQQ	ETF	101.91	102.0	101.8	101.8	15850.0
2016-01-15 06:00:00	QQQ	ETF	101.81	102.06	101.73	101.87	7160.0
2016-01-15 06:30:00	QQQ	ETF	102.0	102.18	101.98	102.09	15200.0
2016-01-15 07:00:00	QQQ	ETF	102.05	102.29	102.0	102.0	46049.0
2016-01-15 07:30:00	QQQ	ETF	102.01	102.2	101.9	102.17	107135.0
2016-01-15 08:00:00	QQQ	ETF	102.17	102.19	101.81	101.92	113325.0
2016-01-15 08:30:00	QQQ	ETF	101.99	102.08	100.79	101.13	1005139.0
2016-01-15 09:00:00	QQQ	ETF	101.13	101.18	100.44	100.58	1273688.0
2016-01-15 09:30:00	QQQ	ETF	100.57	101.94	100.44	101.13	11908485.0
2016-01-15 10:00:00	QQQ	ETF	101.13	101.76	100.88	101.44	7353682.0
2016-01-15 10:30:00	QQQ	ETF	101.44	101.83	100.72	100.795	6269866.0
2016-01-15 11:00:00	QQQ	ETF	100.8	100.93	100.54	100.93	5585467.0
2016-01-15 11:30:00	QQQ	ETF	100.93	101.0856	100.46	100.61	4207153.0
2016-01-15 12:00:00	QQQ	ETF	100.62	100.7	99.86	100.0	5526530.0
2016-01-15 12:30:00	QQQ	ETF	100.0	100.43	99.51	100.37	5553669.0

> showing 50 of 14,514 rows — these rows as CSV

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