PREVIEW / etf_30min / 2016-03-03

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-03.parquet
  size:    392 KB
  rows:    13,227

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-03-03 04:00:00	SPY	ETF	198.75	199.06	198.72	199.06	7019.0
2016-03-03 04:30:00	SPY	ETF	198.89	199.17	198.89	199.07	8281.0
2016-03-03 05:00:00	SPY	ETF	199.12	199.18	198.98	198.99	9499.0
2016-03-03 05:30:00	SPY	ETF	199.07	199.25	199.07	199.25	8473.0
2016-03-03 06:00:00	SPY	ETF	199.25	199.25	199.04	199.11	30675.0
2016-03-03 06:30:00	SPY	ETF	199.04	199.04	198.84	198.95	40397.0
2016-03-03 07:00:00	SPY	ETF	198.94	198.97	198.86	198.87	61991.0
2016-03-03 07:30:00	SPY	ETF	198.91	198.92	198.69	198.86	201271.0
2016-03-03 08:00:00	SPY	ETF	198.84	198.92	198.71	198.83	225817.0
2016-03-03 08:30:00	SPY	ETF	198.83	198.89	198.64	198.8	328574.0
2016-03-03 09:00:00	SPY	ETF	198.84	198.86	198.67	198.78	393949.0
2016-03-03 09:30:00	SPY	ETF	198.79	198.81	198.19	198.385	8103434.0
2016-03-03 10:00:00	SPY	ETF	198.385	198.62	198.12	198.5514	10829991.0
2016-03-03 10:30:00	SPY	ETF	198.56	199.0	198.56	198.825	6723969.0
2016-03-03 11:00:00	SPY	ETF	198.82	198.92	198.12	198.207	6781849.0
2016-03-03 11:30:00	SPY	ETF	198.2	198.54	198.11	198.49	6280664.0
2016-03-03 12:00:00	SPY	ETF	198.5	198.64	198.27	198.31	4046406.0
2016-03-03 12:30:00	SPY	ETF	198.31	198.71	198.29	198.67	3949469.0
2016-03-03 13:00:00	SPY	ETF	198.6625	198.98	198.66	198.77	2916684.0
2016-03-03 13:30:00	SPY	ETF	198.76	199.26	198.76	199.16	6107390.0
2016-03-03 14:00:00	SPY	ETF	199.16	199.37	198.96	199.16	4985796.0
2016-03-03 14:30:00	SPY	ETF	199.17	199.49	199.0	199.36	5868982.0
2016-03-03 15:00:00	SPY	ETF	199.37	199.56	199.2	199.43	7389083.0
2016-03-03 15:30:00	SPY	ETF	199.43	199.795	199.36	199.76	13344382.0
2016-03-03 16:00:00	SPY	ETF	199.76	199.78	198.8247	199.67	2974897.0
2016-03-03 16:30:00	SPY	ETF	199.69	199.84	199.67	199.77	282882.0
2016-03-03 17:00:00	SPY	ETF	199.78	199.84	199.74	199.8	82371.0
2016-03-03 17:30:00	SPY	ETF	199.8	199.83	199.77	199.77	60266.0
2016-03-03 18:00:00	SPY	ETF	199.77	199.77	199.6	199.6	104935.0
2016-03-03 18:30:00	SPY	ETF	199.63	199.65	199.57	199.59	15854.0
2016-03-03 19:00:00	SPY	ETF	199.62	199.65	199.58	199.65	8475.0
2016-03-03 19:30:00	SPY	ETF	199.64	199.68	199.62	199.68	21208.0
2016-03-03 04:30:00	QQQ	ETF	105.89	105.89	105.89	105.89	100.0
2016-03-03 05:00:00	QQQ	ETF	105.94	105.94	105.94	105.94	1000.0
2016-03-03 05:30:00	QQQ	ETF	105.97	105.97	105.97	105.97	2298.0
2016-03-03 06:00:00	QQQ	ETF	106.0	106.0	105.86	105.86	1798.0
2016-03-03 06:30:00	QQQ	ETF	105.76	105.76	105.69	105.69	901.0
2016-03-03 07:00:00	QQQ	ETF	105.73	105.75	105.71	105.73	1814.0
2016-03-03 07:30:00	QQQ	ETF	105.73	105.73	105.62	105.73	25212.0
2016-03-03 08:00:00	QQQ	ETF	105.76	105.77	105.64	105.71	44603.0
2016-03-03 08:30:00	QQQ	ETF	105.7	105.77	105.64	105.77	17569.0
2016-03-03 09:00:00	QQQ	ETF	105.74	105.74	105.68	105.7	50658.0
2016-03-03 09:30:00	QQQ	ETF	105.71	105.75	105.3	105.39	2860371.0
2016-03-03 10:00:00	QQQ	ETF	105.4	105.5294	105.09	105.3	1954403.0
2016-03-03 10:30:00	QQQ	ETF	105.3	105.49	105.28	105.36	1283081.0
2016-03-03 11:00:00	QQQ	ETF	105.36	105.4062	104.92	104.9611	1951276.0
2016-03-03 11:30:00	QQQ	ETF	104.97	105.1386	104.87	105.12	1389537.0
2016-03-03 12:00:00	QQQ	ETF	105.12	105.228	105.01	105.035	920779.0
2016-03-03 12:30:00	QQQ	ETF	105.03	105.22	105.002	105.14	766553.0
2016-03-03 13:00:00	QQQ	ETF	105.14	105.32	105.14	105.19	822193.0

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

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