PREVIEW / etf_30min / 2015-10-07

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-07.parquet
  size:    388 KB
  rows:    13,137

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
2015-10-07 04:00:00	SPY	ETF	198.82	199.25	198.8	199.15	31163.0
2015-10-07 04:30:00	SPY	ETF	199.23	199.29	198.79	199.05	42190.0
2015-10-07 05:00:00	SPY	ETF	199.03	199.05	198.85	198.85	13815.0
2015-10-07 05:30:00	SPY	ETF	198.87	198.98	198.47	198.55	9484.0
2015-10-07 06:00:00	SPY	ETF	198.57	198.74	198.35	198.35	22151.0
2015-10-07 06:30:00	SPY	ETF	198.37	198.55	198.3	198.5	44295.0
2015-10-07 07:00:00	SPY	ETF	198.48	198.95	198.48	198.91	186567.0
2015-10-07 07:30:00	SPY	ETF	198.91	199.01	198.71	198.82	273849.0
2015-10-07 08:00:00	SPY	ETF	198.79	198.88	198.61	198.85	442729.0
2015-10-07 08:30:00	SPY	ETF	198.85	198.97	198.67	198.73	511766.0
2015-10-07 09:00:00	SPY	ETF	198.74	198.99	198.74	198.91	378834.0
2015-10-07 09:30:00	SPY	ETF	198.9	199.59	198.8	199.43	12018418.0
2015-10-07 10:00:00	SPY	ETF	199.445	199.825	199.32	199.62	9329842.0
2015-10-07 10:30:00	SPY	ETF	199.62	199.62	198.38	198.82	12198641.0
2015-10-07 11:00:00	SPY	ETF	198.82	198.82	197.48	197.62	14153669.0
2015-10-07 11:30:00	SPY	ETF	197.62	199.07	197.49	198.42	9302620.0
2015-10-07 12:00:00	SPY	ETF	198.41	198.505	197.7	197.84	6425380.0
2015-10-07 12:30:00	SPY	ETF	197.83	199.0	197.77	198.11	4882518.0
2015-10-07 13:00:00	SPY	ETF	198.11	198.6899	197.99	198.55	4460842.0
2015-10-07 13:30:00	SPY	ETF	198.57	199.26	198.57	199.1	6481647.0
2015-10-07 14:00:00	SPY	ETF	199.1	199.48	198.6664	198.89	7076867.0
2015-10-07 14:30:00	SPY	ETF	198.89	199.1	198.44	198.53	7991074.0
2015-10-07 15:00:00	SPY	ETF	198.54	199.17	198.47	198.75	8003391.0
2015-10-07 15:30:00	SPY	ETF	198.755	199.47	198.755	199.45	12120733.0
2015-10-07 16:00:00	SPY	ETF	199.45	199.6	198.28	199.38	5102099.0
2015-10-07 16:30:00	SPY	ETF	199.38	199.59	199.36	199.56	957731.0
2015-10-07 17:00:00	SPY	ETF	199.56	199.61	199.54	199.57	312108.0
2015-10-07 17:30:00	SPY	ETF	199.53	199.58	199.41	199.48	186403.0
2015-10-07 18:00:00	SPY	ETF	199.47	199.62	199.44	199.48	107141.0
2015-10-07 18:30:00	SPY	ETF	199.49	199.55	199.48	199.5	5735.0
2015-10-07 19:00:00	SPY	ETF	199.51	199.55	199.44	199.47	20871.0
2015-10-07 19:30:00	SPY	ETF	199.49	199.5	199.37	199.38	67477.0
2015-10-07 04:00:00	QQQ	ETF	105.6	105.78	105.52	105.78	1371.0
2015-10-07 04:30:00	QQQ	ETF	105.86	105.86	105.68	105.68	2400.0
2015-10-07 05:00:00	QQQ	ETF	105.7	105.7	105.66	105.66	600.0
2015-10-07 05:30:00	QQQ	ETF	105.62	105.7	105.62	105.68	1700.0
2015-10-07 06:00:00	QQQ	ETF	105.55	105.56	105.51	105.51	1510.0
2015-10-07 06:30:00	QQQ	ETF	105.43	105.49	105.43	105.49	1500.0
2015-10-07 07:00:00	QQQ	ETF	105.48	105.73	105.48	105.71	22850.0
2015-10-07 07:30:00	QQQ	ETF	105.7	105.77	105.63	105.68	11845.0
2015-10-07 08:00:00	QQQ	ETF	105.66	105.72	105.6	105.67	54304.0
2015-10-07 08:30:00	QQQ	ETF	105.73	105.77	105.63	105.64	85644.0
2015-10-07 09:00:00	QQQ	ETF	105.65	105.75	105.61	105.68	117470.0
2015-10-07 09:30:00	QQQ	ETF	105.66	105.83	105.25	105.72	4484097.0
2015-10-07 10:00:00	QQQ	ETF	105.73	105.86	105.49	105.56	2372606.0
2015-10-07 10:30:00	QQQ	ETF	105.56	105.565	104.74	104.99	3658858.0
2015-10-07 11:00:00	QQQ	ETF	104.99	104.99	104.32	104.37	3312806.0
2015-10-07 11:30:00	QQQ	ETF	104.36	105.04	104.29	104.99	3235619.0
2015-10-07 12:00:00	QQQ	ETF	104.98	105.02	104.5	104.5769	2437907.0
2015-10-07 12:30:00	QQQ	ETF	104.58	104.889	104.51	104.68	1269973.0

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

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