PREVIEW / etf_30min / 2016-01-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-14.parquet
  size:    412 KB
  rows:    13,872

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-14 04:00:00	SPY	ETF	188.94	189.1	188.45	188.93	26767.0
2016-01-14 04:30:00	SPY	ETF	188.92	189.55	188.8	189.18	16956.0
2016-01-14 05:00:00	SPY	ETF	189.15	189.4	188.73	188.8	15874.0
2016-01-14 05:30:00	SPY	ETF	188.7	188.97	188.5	188.63	29402.0
2016-01-14 06:00:00	SPY	ETF	188.69	188.75	188.09	188.28	152848.0
2016-01-14 06:30:00	SPY	ETF	188.44	188.77	188.18	188.61	136438.0
2016-01-14 07:00:00	SPY	ETF	188.68	189.03	188.6	188.73	202779.0
2016-01-14 07:30:00	SPY	ETF	188.73	189.66	188.73	189.54	443314.0
2016-01-14 08:00:00	SPY	ETF	189.55	189.69	188.55	189.61	1758284.0
2016-01-14 08:30:00	SPY	ETF	189.61	190.0	188.8268	189.79	3567488.0
2016-01-14 09:00:00	SPY	ETF	189.78	190.02	188.85	189.56	1617065.0
2016-01-14 09:30:00	SPY	ETF	189.55	189.8	187.77	187.94	26684757.0
2016-01-14 10:00:00	SPY	ETF	187.94	190.31	187.66	190.3	32125127.0
2016-01-14 10:30:00	SPY	ETF	190.29	191.67	190.05	190.835	28293967.0
2016-01-14 11:00:00	SPY	ETF	190.84	191.19	190.11	190.45	13096669.0
2016-01-14 11:30:00	SPY	ETF	190.44	191.0	190.0	190.94	9877049.0
2016-01-14 12:00:00	SPY	ETF	190.93	191.31	190.46	191.08	8973444.0
2016-01-14 12:30:00	SPY	ETF	191.09	191.78	190.93	191.1	11664847.0
2016-01-14 13:00:00	SPY	ETF	191.1	192.32	191.01	192.23	11233590.0
2016-01-14 13:30:00	SPY	ETF	192.24	192.41	191.73	192.231	8154178.0
2016-01-14 14:00:00	SPY	ETF	192.24	192.49	191.83	192.27	13715485.0
2016-01-14 14:30:00	SPY	ETF	192.26	193.03	192.09	192.95	11663098.0
2016-01-14 15:00:00	SPY	ETF	192.95	193.26	192.77	192.775	12934601.0
2016-01-14 15:30:00	SPY	ETF	192.77	192.81	191.67	191.89	27576299.0
2016-01-14 16:00:00	SPY	ETF	191.88	192.36	191.68	191.87	11605483.0
2016-01-14 16:30:00	SPY	ETF	191.87	191.92	191.73	191.77	1409563.0
2016-01-14 17:00:00	SPY	ETF	191.75	191.75	191.32	191.45	493061.0
2016-01-14 17:30:00	SPY	ETF	191.46	191.84	191.46	191.84	161877.0
2016-01-14 18:00:00	SPY	ETF	191.84	192.36	191.72	192.28	772865.0
2016-01-14 18:30:00	SPY	ETF	192.25	192.34	192.11	192.25	72678.0
2016-01-14 19:00:00	SPY	ETF	192.27	192.53	192.24	192.36	106437.0
2016-01-14 19:30:00	SPY	ETF	192.32	192.36	191.75	191.83	82122.0
2016-01-14 20:00:00	SPY	ETF	191.9702	191.9702	191.9702	191.9702	1000000.0
2016-01-14 04:00:00	QQQ	ETF	102.1	102.1	101.82	101.88	700.0
2016-01-14 04:30:00	QQQ	ETF	102.11	102.12	102.05	102.09	5500.0
2016-01-14 05:00:00	QQQ	ETF	102.16	102.16	101.88	101.88	800.0
2016-01-14 05:30:00	QQQ	ETF	101.77	101.93	101.7	101.77	4800.0
2016-01-14 06:00:00	QQQ	ETF	101.8	101.83	101.39	101.54	20405.0
2016-01-14 06:30:00	QQQ	ETF	101.58	101.77	101.51	101.66	10078.0
2016-01-14 07:00:00	QQQ	ETF	101.72	101.83	101.66	101.77	9050.0
2016-01-14 07:30:00	QQQ	ETF	101.86	102.31	101.86	102.24	33768.0
2016-01-14 08:00:00	QQQ	ETF	102.26	102.28	101.98	102.19	140834.0
2016-01-14 08:30:00	QQQ	ETF	102.18	102.46	102.11	102.4	235099.0
2016-01-14 09:00:00	QQQ	ETF	102.39	102.58	102.28	102.29	788864.0
2016-01-14 09:30:00	QQQ	ETF	102.3	102.44	100.835	100.91	9673700.0
2016-01-14 10:00:00	QQQ	ETF	100.91	102.62	100.67	102.61	11041929.0
2016-01-14 10:30:00	QQQ	ETF	102.61	103.471	102.48	102.91	8667680.0
2016-01-14 11:00:00	QQQ	ETF	102.91	103.12	102.51	102.78	4375957.0
2016-01-14 11:30:00	QQQ	ETF	102.79	103.23	102.48	103.21	2884073.0
2016-01-14 12:00:00	QQQ	ETF	103.215	103.51	102.99	103.35	2815367.0

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

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