PREVIEW / etf_30min / 2016-11-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-15.parquet
  size:    436 KB
  rows:    14,788

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-11-15 04:00:00	SPY	ETF	217.29	217.42	216.89	217.21	19616.0
2016-11-15 04:30:00	SPY	ETF	217.2	217.29	216.89	216.89	7681.0
2016-11-15 05:00:00	SPY	ETF	217.01	217.12	216.97	217.02	7239.0
2016-11-15 05:30:00	SPY	ETF	217.02	217.04	216.95	216.95	3981.0
2016-11-15 06:00:00	SPY	ETF	216.94	216.99	216.71	216.84	23509.0
2016-11-15 06:30:00	SPY	ETF	216.85	216.93	216.85	216.91	12800.0
2016-11-15 07:00:00	SPY	ETF	216.89	216.91	216.75	216.75	78411.0
2016-11-15 07:30:00	SPY	ETF	216.81	216.81	216.66	216.76	48800.0
2016-11-15 08:00:00	SPY	ETF	216.76	217.1	216.7	217.08	388106.0
2016-11-15 08:30:00	SPY	ETF	217.1	217.22	216.96	217.05	339283.0
2016-11-15 09:00:00	SPY	ETF	217.02	217.07	216.87	217.03	645328.0
2016-11-15 09:30:00	SPY	ETF	217.04	217.24	216.8	216.96	9190544.0
2016-11-15 10:00:00	SPY	ETF	216.96	217.43	216.94	217.23	6462665.0
2016-11-15 10:30:00	SPY	ETF	217.24	217.28	217.03	217.28	4426922.0
2016-11-15 11:00:00	SPY	ETF	217.27	217.46	217.21	217.2473	4602639.0
2016-11-15 11:30:00	SPY	ETF	217.25	217.4	217.09	217.2499	3454105.0
2016-11-15 12:00:00	SPY	ETF	217.24	217.42	217.15	217.25	5216558.0
2016-11-15 12:30:00	SPY	ETF	217.25	217.36	217.0	217.0489	3125532.0
2016-11-15 13:00:00	SPY	ETF	217.04	217.27	217.04	217.1683	2389426.0
2016-11-15 13:30:00	SPY	ETF	217.16	217.43	217.15	217.405	2890615.0
2016-11-15 14:00:00	SPY	ETF	217.4	217.65	217.33	217.59	3752420.0
2016-11-15 14:30:00	SPY	ETF	217.59	218.14	217.58	218.0601	7574766.0
2016-11-15 15:00:00	SPY	ETF	218.06	218.2089	217.93	218.085	8321073.0
2016-11-15 15:30:00	SPY	ETF	218.08	218.28	217.99	218.25	16657571.0
2016-11-15 16:00:00	SPY	ETF	218.24	218.47	217.23	218.42	6697310.0
2016-11-15 16:30:00	SPY	ETF	218.43	218.43	218.2089	218.39	3388275.0
2016-11-15 17:00:00	SPY	ETF	218.37	218.39	218.33	218.37	76872.0
2016-11-15 17:30:00	SPY	ETF	218.37	218.4	218.36	218.38	25291.0
2016-11-15 18:00:00	SPY	ETF	218.38	218.42	218.36	218.39	58270.0
2016-11-15 18:30:00	SPY	ETF	218.39	218.48	218.34	218.44	14778.0
2016-11-15 19:00:00	SPY	ETF	218.41	218.97	218.35	218.82	95987.0
2016-11-15 19:30:00	SPY	ETF	218.84	218.84	218.56	218.67	101084.0
2016-11-15 04:00:00	QQQ	ETF	114.76	115.04	114.76	115.02	1450.0
2016-11-15 04:30:00	QQQ	ETF	115.0	115.0	114.89	114.89	2651.0
2016-11-15 05:00:00	QQQ	ETF	114.87	114.87	114.87	114.87	1700.0
2016-11-15 05:30:00	QQQ	ETF	114.89	114.89	114.89	114.89	1000.0
2016-11-15 06:00:00	QQQ	ETF	114.85	114.85	114.82	114.82	1200.0
2016-11-15 06:30:00	QQQ	ETF	114.81	114.81	114.69	114.7	6450.0
2016-11-15 07:00:00	QQQ	ETF	114.71	114.74	114.69	114.74	3051.0
2016-11-15 07:30:00	QQQ	ETF	114.73	114.73	114.58	114.64	19581.0
2016-11-15 08:00:00	QQQ	ETF	114.69	115.16	114.63	115.16	51502.0
2016-11-15 08:30:00	QQQ	ETF	115.18	115.46	115.11	115.39	262083.0
2016-11-15 09:00:00	QQQ	ETF	115.38	115.48	115.25	115.46	225573.0
2016-11-15 09:30:00	QQQ	ETF	115.47	115.9899	115.33	115.9799	4182352.0
2016-11-15 10:00:00	QQQ	ETF	115.97	116.55	115.94	116.245	3299989.0
2016-11-15 10:30:00	QQQ	ETF	116.245	116.27	115.87	116.13	3045091.0
2016-11-15 11:00:00	QQQ	ETF	116.125	116.28	115.95	116.08	1723355.0
2016-11-15 11:30:00	QQQ	ETF	116.09	116.175	115.98	116.05	1020768.0
2016-11-15 12:00:00	QQQ	ETF	116.0452	116.15	115.96	115.98	718967.0
2016-11-15 12:30:00	QQQ	ETF	115.98	116.035	115.67	115.73	959628.0

> showing 50 of 14,788 rows — these rows as CSV

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