PREVIEW / etf_30min / 2016-12-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-08.parquet
  size:    450 KB
  rows:    15,273

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-12-08 04:00:00	SPY	ETF	224.35	224.35	224.07	224.19	7630.0
2016-12-08 04:30:00	SPY	ETF	224.25	224.27	224.11	224.2	5306.0
2016-12-08 05:00:00	SPY	ETF	224.18	224.32	224.15	224.3	3008.0
2016-12-08 05:30:00	SPY	ETF	224.38	224.41	224.34	224.4	6765.0
2016-12-08 06:00:00	SPY	ETF	224.46	224.46	224.3	224.31	14161.0
2016-12-08 06:30:00	SPY	ETF	224.31	224.35	224.22	224.35	73094.0
2016-12-08 07:00:00	SPY	ETF	224.3	224.44	224.3	224.44	87284.0
2016-12-08 07:30:00	SPY	ETF	224.44	224.61	223.8	224.4	540980.0
2016-12-08 08:00:00	SPY	ETF	224.31	224.51	224.07	224.41	332051.0
2016-12-08 08:30:00	SPY	ETF	224.38	224.71	224.26	224.51	519954.0
2016-12-08 09:00:00	SPY	ETF	224.52	224.72	224.47	224.59	525649.0
2016-12-08 09:30:00	SPY	ETF	224.57	224.94	224.35	224.58	10416986.0
2016-12-08 10:00:00	SPY	ETF	224.58	224.585	224.26	224.51	6799096.0
2016-12-08 10:30:00	SPY	ETF	224.515	224.78	224.45	224.71	4119001.0
2016-12-08 11:00:00	SPY	ETF	224.71	224.93	224.59	224.75	5376731.0
2016-12-08 11:30:00	SPY	ETF	224.755	224.87	224.57	224.79	5361544.0
2016-12-08 12:00:00	SPY	ETF	224.79	225.41	224.78	225.27	4306106.0
2016-12-08 12:30:00	SPY	ETF	225.26	225.59	225.22	225.33	5774382.0
2016-12-08 13:00:00	SPY	ETF	225.33	225.38	225.19	225.291	4560558.0
2016-12-08 13:30:00	SPY	ETF	225.3	225.7	225.2	225.64	5559045.0
2016-12-08 14:00:00	SPY	ETF	225.64	225.65	225.03	225.25	5602638.0
2016-12-08 14:30:00	SPY	ETF	225.25	225.31	224.78	225.07	11471242.0
2016-12-08 15:00:00	SPY	ETF	225.01	225.17	224.88	224.92	4930431.0
2016-12-08 15:30:00	SPY	ETF	224.93	225.3	224.91	225.14	10421092.0
2016-12-08 16:00:00	SPY	ETF	225.14	225.36	225.12	225.33	6839875.0
2016-12-08 16:30:00	SPY	ETF	225.33	225.33	224.9722	225.32	659816.0
2016-12-08 17:00:00	SPY	ETF	225.32	225.33	225.15	225.31	473044.0
2016-12-08 17:30:00	SPY	ETF	225.32	225.8652	225.24	225.24	3297161.0
2016-12-08 18:00:00	SPY	ETF	225.25	225.33	225.25	225.27	73585.0
2016-12-08 18:30:00	SPY	ETF	225.28	225.32	225.27	225.28	36379.0
2016-12-08 19:00:00	SPY	ETF	225.26	225.33	225.25	225.32	48465.0
2016-12-08 19:30:00	SPY	ETF	225.33	225.36	225.3	225.33	14351.0
2016-12-08 04:00:00	QQQ	ETF	118.22	118.22	118.2	118.2	500.0
2016-12-08 04:30:00	QQQ	ETF	118.24	118.24	118.24	118.24	150.0
2016-12-08 05:00:00	QQQ	ETF	118.24	118.24	118.24	118.24	1300.0
2016-12-08 05:30:00	QQQ	ETF	118.36	118.36	118.35	118.35	2900.0
2016-12-08 06:00:00	QQQ	ETF	118.35	118.35	118.35	118.35	200.0
2016-12-08 07:00:00	QQQ	ETF	118.28	118.32	118.28	118.32	630.0
2016-12-08 07:30:00	QQQ	ETF	118.21	118.41	118.1	118.31	53187.0
2016-12-08 08:00:00	QQQ	ETF	118.31	118.33	118.1	118.26	39874.0
2016-12-08 08:30:00	QQQ	ETF	118.29	118.44	118.15	118.32	101835.0
2016-12-08 09:00:00	QQQ	ETF	118.35	118.49	118.3	118.39	49855.0
2016-12-08 09:30:00	QQQ	ETF	118.4	118.76	118.18	118.49	3259057.0
2016-12-08 10:00:00	QQQ	ETF	118.47	118.7	118.3	118.66	1423339.0
2016-12-08 10:30:00	QQQ	ETF	118.66	118.74	118.47	118.67	1055279.0
2016-12-08 11:00:00	QQQ	ETF	118.66	118.8357	118.59	118.67	1094346.0
2016-12-08 11:30:00	QQQ	ETF	118.679	118.71	118.48	118.6	791353.0
2016-12-08 12:00:00	QQQ	ETF	118.61	118.86	118.56	118.76	826920.0
2016-12-08 12:30:00	QQQ	ETF	118.75	118.87	118.66	118.69	908413.0
2016-12-08 13:00:00	QQQ	ETF	118.69	118.72	118.479	118.575	811116.0

> showing 50 of 15,273 rows — these rows as CSV

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