PREVIEW / etf_30min / 2016-09-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-06.parquet
  size:    403 KB
  rows:    13,793

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-09-06 04:00:00	SPY	ETF	218.37	218.5	218.37	218.49	2129.0
2016-09-06 04:30:00	SPY	ETF	218.55	218.58	218.51	218.55	6704.0
2016-09-06 05:00:00	SPY	ETF	218.55	218.65	218.55	218.65	5754.0
2016-09-06 06:00:00	SPY	ETF	218.57	218.57	218.48	218.49	4234.0
2016-09-06 06:30:00	SPY	ETF	218.5	218.53	218.48	218.5	2152.0
2016-09-06 07:00:00	SPY	ETF	218.5	218.52	218.41	218.49	14184.0
2016-09-06 07:30:00	SPY	ETF	218.49	218.56	218.47	218.53	60848.0
2016-09-06 08:00:00	SPY	ETF	218.54	218.55	218.321	218.51	246387.0
2016-09-06 08:30:00	SPY	ETF	218.51	218.51	218.39	218.5	134288.0
2016-09-06 09:00:00	SPY	ETF	218.47	218.72	218.47	218.69	236261.0
2016-09-06 09:30:00	SPY	ETF	218.7	218.79	218.45	218.57	5764550.0
2016-09-06 10:00:00	SPY	ETF	218.57	218.7	217.86	218.04	8113943.0
2016-09-06 10:30:00	SPY	ETF	218.03	218.215	217.93	218.11	3804056.0
2016-09-06 11:00:00	SPY	ETF	218.11	218.395	218.0202	218.35	2926004.0
2016-09-06 11:30:00	SPY	ETF	218.34	218.69	218.27	218.669	3561507.0
2016-09-06 12:00:00	SPY	ETF	218.67	218.74	218.56	218.635	1650737.0
2016-09-06 12:30:00	SPY	ETF	218.63	218.87	218.6	218.7201	3160307.0
2016-09-06 13:00:00	SPY	ETF	218.72	218.7501	218.61	218.61	1771858.0
2016-09-06 13:30:00	SPY	ETF	218.62	218.75	218.58	218.67	1462901.0
2016-09-06 14:00:00	SPY	ETF	218.668	218.77	218.58	218.7	1478325.0
2016-09-06 14:30:00	SPY	ETF	218.705	218.79	218.64	218.78	1671906.0
2016-09-06 15:00:00	SPY	ETF	218.78	218.8	218.6027	218.73	2842607.0
2016-09-06 15:30:00	SPY	ETF	218.73	219.09	218.661	219.07	9445011.0
2016-09-06 16:00:00	SPY	ETF	219.06	219.16	218.94	219.03	6527601.0
2016-09-06 16:30:00	SPY	ETF	219.03	219.11	219.01	219.09	951161.0
2016-09-06 17:00:00	SPY	ETF	219.0236	219.1	219.0236	219.1	65351.0
2016-09-06 17:30:00	SPY	ETF	219.09	219.1	219.03	219.03	69011.0
2016-09-06 18:00:00	SPY	ETF	219.07	219.07	219.0	219.02	75346.0
2016-09-06 18:30:00	SPY	ETF	219.02	219.04	219.0	219.02	9528.0
2016-09-06 19:00:00	SPY	ETF	219.02	219.02	218.97	218.97	23975.0
2016-09-06 19:30:00	SPY	ETF	219.0	219.02	218.99	219.01	8244.0
2016-09-06 04:00:00	QQQ	ETF	117.12	117.12	117.1	117.1	10200.0
2016-09-06 04:30:00	QQQ	ETF	117.17	117.17	117.17	117.17	100.0
2016-09-06 05:00:00	QQQ	ETF	117.2	117.2	117.2	117.2	10000.0
2016-09-06 06:30:00	QQQ	ETF	117.13	117.13	117.13	117.13	100.0
2016-09-06 07:00:00	QQQ	ETF	117.14	117.14	117.14	117.14	2145.0
2016-09-06 07:30:00	QQQ	ETF	117.14	117.19	117.13	117.19	9442.0
2016-09-06 08:00:00	QQQ	ETF	117.17	117.17	117.14	117.15	9673.0
2016-09-06 08:30:00	QQQ	ETF	117.16	117.2	117.14	117.2	13112.0
2016-09-06 09:00:00	QQQ	ETF	117.2	117.31	117.2	117.3	72011.0
2016-09-06 09:30:00	QQQ	ETF	117.29	117.52	117.13	117.47	2148533.0
2016-09-06 10:00:00	QQQ	ETF	117.46	117.6	117.06	117.2	2827064.0
2016-09-06 10:30:00	QQQ	ETF	117.2	117.36	117.19	117.3399	946143.0
2016-09-06 11:00:00	QQQ	ETF	117.33	117.5	117.316	117.445	666400.0
2016-09-06 11:30:00	QQQ	ETF	117.44	117.67	117.36	117.655	1207119.0
2016-09-06 12:00:00	QQQ	ETF	117.66	117.69	117.6134	117.655	532282.0
2016-09-06 12:30:00	QQQ	ETF	117.65	117.83	117.64	117.73	1144564.0
2016-09-06 13:00:00	QQQ	ETF	117.73	117.76	117.63	117.64	447508.0
2016-09-06 13:30:00	QQQ	ETF	117.64	117.7	117.6035	117.64	682412.0
2016-09-06 14:00:00	QQQ	ETF	117.645	117.72	117.59	117.68	615932.0

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

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