PREVIEW / etf_30min / 2016-12-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-20.parquet
  size:    436 KB
  rows:    15,022

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-20 04:00:00	SPY	ETF	225.94	225.98	225.94	225.98	1753.0
2016-12-20 04:30:00	SPY	ETF	225.9	225.9	225.82	225.9	602.0
2016-12-20 05:00:00	SPY	ETF	225.9	225.93	225.85	225.93	6999.0
2016-12-20 05:30:00	SPY	ETF	225.95	225.98	225.95	225.96	800.0
2016-12-20 06:00:00	SPY	ETF	225.95	226.01	225.92	226.0	19603.0
2016-12-20 06:30:00	SPY	ETF	226.0	226.08	225.99	226.04	10354.0
2016-12-20 07:00:00	SPY	ETF	226.02	226.17	226.02	226.14	102455.0
2016-12-20 07:30:00	SPY	ETF	226.12	226.33	226.11	226.32	152384.0
2016-12-20 08:00:00	SPY	ETF	226.27	226.4	226.09	226.26	174738.0
2016-12-20 08:30:00	SPY	ETF	226.25	226.29	226.17	226.24	98314.0
2016-12-20 09:00:00	SPY	ETF	226.24	226.25	226.14	226.16	279070.0
2016-12-20 09:30:00	SPY	ETF	226.15	226.57	226.06	226.42	7281882.0
2016-12-20 10:00:00	SPY	ETF	226.43	226.44	226.13	226.21	5360317.0
2016-12-20 10:30:00	SPY	ETF	226.2066	226.48	226.16	226.45	7330205.0
2016-12-20 11:00:00	SPY	ETF	226.46	226.48	226.35	226.38	2542843.0
2016-12-20 11:30:00	SPY	ETF	226.39	226.39	225.97	226.12	6609401.0
2016-12-20 12:00:00	SPY	ETF	226.13	226.255	226.04	226.15	3113846.0
2016-12-20 12:30:00	SPY	ETF	226.15	226.3	226.12	226.2411	3673403.0
2016-12-20 13:00:00	SPY	ETF	226.2471	226.38	226.24	226.35	5566469.0
2016-12-20 13:30:00	SPY	ETF	226.34	226.4	226.2	226.34	5242558.0
2016-12-20 14:00:00	SPY	ETF	226.33	226.35	226.13	226.17	4018194.0
2016-12-20 14:30:00	SPY	ETF	226.17	226.18	225.88	226.05	5907785.0
2016-12-20 15:00:00	SPY	ETF	226.05	226.2	226.02	226.2	9902265.0
2016-12-20 15:30:00	SPY	ETF	226.2	226.39	226.09	226.37	11424793.0
2016-12-20 16:00:00	SPY	ETF	226.36	226.4	226.22	226.31	4510745.0
2016-12-20 16:30:00	SPY	ETF	226.4	226.41	226.24	226.35	2779148.0
2016-12-20 17:00:00	SPY	ETF	226.34	226.4	226.33	226.34	28543.0
2016-12-20 17:30:00	SPY	ETF	226.38	226.38	226.35	226.37	8747.0
2016-12-20 18:00:00	SPY	ETF	226.39	226.4	226.31	226.39	68134.0
2016-12-20 18:30:00	SPY	ETF	226.37	226.37	226.31	226.34	15670.0
2016-12-20 19:00:00	SPY	ETF	226.33	226.36	226.27	226.36	63932.0
2016-12-20 19:30:00	SPY	ETF	226.36	226.38	226.33	226.38	17377.0
2016-12-20 06:30:00	QQQ	ETF	120.31	120.31	120.31	120.31	750.0
2016-12-20 07:00:00	QQQ	ETF	120.3	120.35	120.3	120.32	5750.0
2016-12-20 07:30:00	QQQ	ETF	120.39	120.41	120.39	120.4	2912.0
2016-12-20 08:00:00	QQQ	ETF	120.33	120.5	120.33	120.5	18566.0
2016-12-20 08:30:00	QQQ	ETF	120.42	120.49	120.41	120.47	46604.0
2016-12-20 09:00:00	QQQ	ETF	120.48	120.48	120.41	120.42	51522.0
2016-12-20 09:30:00	QQQ	ETF	120.43	120.77	120.39	120.59	1557999.0
2016-12-20 10:00:00	QQQ	ETF	120.59	120.66	120.39	120.46	947573.0
2016-12-20 10:30:00	QQQ	ETF	120.46	120.6633	120.44	120.645	849642.0
2016-12-20 11:00:00	QQQ	ETF	120.645	120.66	120.531	120.6	517614.0
2016-12-20 11:30:00	QQQ	ETF	120.6	120.6	120.408	120.5	740176.0
2016-12-20 12:00:00	QQQ	ETF	120.49	120.56	120.45	120.52	563913.0
2016-12-20 12:30:00	QQQ	ETF	120.51	120.62	120.49	120.595	381735.0
2016-12-20 13:00:00	QQQ	ETF	120.59	120.66	120.57	120.62	402605.0
2016-12-20 13:30:00	QQQ	ETF	120.6207	120.66	120.51	120.58	510239.0
2016-12-20 14:00:00	QQQ	ETF	120.58	120.59	120.47	120.5	383684.0
2016-12-20 14:30:00	QQQ	ETF	120.5	120.51	120.33	120.427	554891.0
2016-12-20 15:00:00	QQQ	ETF	120.425	120.56	120.4035	120.54	1041294.0

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

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