PREVIEW / etf_30min / 2016-02-17

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-17.parquet
  size:    402 KB
  rows:    13,565

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-17 04:00:00	SPY	ETF	189.72	190.05	189.59	190.03	11768.0
2016-02-17 04:30:00	SPY	ETF	190.1	190.5	190.1	190.33	11827.0
2016-02-17 05:00:00	SPY	ETF	190.4	190.74	190.33	190.68	22535.0
2016-02-17 05:30:00	SPY	ETF	190.69	190.96	190.63	190.7	61751.0
2016-02-17 06:00:00	SPY	ETF	190.7	190.84	190.64	190.66	23445.0
2016-02-17 06:30:00	SPY	ETF	190.63	190.85	190.63	190.8	119660.0
2016-02-17 07:00:00	SPY	ETF	190.77	190.83	190.66	190.78	189660.0
2016-02-17 07:30:00	SPY	ETF	190.78	191.13	190.78	191.11	438646.0
2016-02-17 08:00:00	SPY	ETF	191.1	191.13	190.75	190.85	424900.0
2016-02-17 08:30:00	SPY	ETF	190.83	191.07	190.73	190.96	530641.0
2016-02-17 09:00:00	SPY	ETF	190.96	191.45	190.94	191.15	1555308.0
2016-02-17 09:30:00	SPY	ETF	191.16	191.765	191.01	191.47	17963233.0
2016-02-17 10:00:00	SPY	ETF	191.48	192.42	191.47	192.4	11110787.0
2016-02-17 10:30:00	SPY	ETF	192.41	192.64	192.125	192.5499	10007714.0
2016-02-17 11:00:00	SPY	ETF	192.54	192.68	192.27	192.5	8844808.0
2016-02-17 11:30:00	SPY	ETF	192.505	192.67	192.3	192.48	7072990.0
2016-02-17 12:00:00	SPY	ETF	192.49	192.8424	192.42	192.76	5443702.0
2016-02-17 12:30:00	SPY	ETF	192.7501	193.02	192.75	192.845	5673326.0
2016-02-17 13:00:00	SPY	ETF	192.86	193.01	192.81	192.93	3797600.0
2016-02-17 13:30:00	SPY	ETF	192.93	192.94	192.53	192.59	6756496.0
2016-02-17 14:00:00	SPY	ETF	192.59	193.32	192.47	193.06	9544427.0
2016-02-17 14:30:00	SPY	ETF	193.06	193.19	192.64	192.72	7204977.0
2016-02-17 15:00:00	SPY	ETF	192.73	193.0	192.6	192.79	8210005.0
2016-02-17 15:30:00	SPY	ETF	192.795	192.99	192.51	192.87	21079557.0
2016-02-17 16:00:00	SPY	ETF	192.88	192.94	192.3	192.87	6717425.0
2016-02-17 16:30:00	SPY	ETF	192.87	193.34	192.87	193.34	979409.0
2016-02-17 17:00:00	SPY	ETF	193.27	193.36	192.87	193.29	105434.0
2016-02-17 17:30:00	SPY	ETF	193.32	193.35	193.26	193.26	114961.0
2016-02-17 18:00:00	SPY	ETF	193.26	193.28	193.13	193.24	163515.0
2016-02-17 18:30:00	SPY	ETF	193.25	193.3	193.17	193.26	48695.0
2016-02-17 19:00:00	SPY	ETF	193.3	193.35	193.13	193.19	216443.0
2016-02-17 19:30:00	SPY	ETF	193.2	193.29	193.13	193.13	177545.0
2016-02-17 04:00:00	QQQ	ETF	100.13	100.13	100.13	100.13	2327.0
2016-02-17 04:30:00	QQQ	ETF	100.3	100.35	100.3	100.35	400.0
2016-02-17 05:00:00	QQQ	ETF	100.5	100.5	100.5	100.5	100.0
2016-02-17 05:30:00	QQQ	ETF	100.63	100.74	100.6	100.63	5495.0
2016-02-17 06:00:00	QQQ	ETF	100.61	100.68	100.6	100.65	1370.0
2016-02-17 06:30:00	QQQ	ETF	100.61	100.61	100.61	100.61	100.0
2016-02-17 07:00:00	QQQ	ETF	100.66	100.8	100.66	100.78	11390.0
2016-02-17 07:30:00	QQQ	ETF	100.83	101.13	100.8	101.13	41600.0
2016-02-17 08:00:00	QQQ	ETF	101.1	101.13	100.75	100.92	77165.0
2016-02-17 08:30:00	QQQ	ETF	100.92	101.01	100.85	100.96	52749.0
2016-02-17 09:00:00	QQQ	ETF	100.97	101.19	100.93	100.99	305289.0
2016-02-17 09:30:00	QQQ	ETF	101.0	101.2	100.7	101.15	6109683.0
2016-02-17 10:00:00	QQQ	ETF	101.15	101.84	101.12	101.84	4134514.0
2016-02-17 10:30:00	QQQ	ETF	101.85	101.94	101.64	101.89	3849063.0
2016-02-17 11:00:00	QQQ	ETF	101.885	101.98	101.68	101.82	2321250.0
2016-02-17 11:30:00	QQQ	ETF	101.83	101.99	101.76	101.879	1438472.0
2016-02-17 12:00:00	QQQ	ETF	101.88	102.3	101.83	102.23	2013183.0
2016-02-17 12:30:00	QQQ	ETF	102.23	102.46	102.23	102.28	2148477.0

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

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