PREVIEW / etf_30min / 2017-10-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-13.parquet
  size:    435 KB
  rows:    15,083

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
2017-10-13 04:00:00	SPY	ETF	254.65	254.65	254.58	254.6	12200.0
2017-10-13 04:30:00	SPY	ETF	254.63	254.63	254.63	254.63	2003.0
2017-10-13 05:00:00	SPY	ETF	254.67	254.71	254.67	254.71	2300.0
2017-10-13 05:30:00	SPY	ETF	254.75	254.8	254.75	254.8	803.0
2017-10-13 06:00:00	SPY	ETF	254.8	254.8	254.8	254.8	300.0
2017-10-13 06:30:00	SPY	ETF	254.8	254.87	254.8	254.87	4400.0
2017-10-13 07:00:00	SPY	ETF	254.87	254.91	254.81	254.83	120371.0
2017-10-13 07:30:00	SPY	ETF	254.87	255.04	254.87	254.97	76568.0
2017-10-13 08:00:00	SPY	ETF	255.0	255.02	254.96	255.0	235163.0
2017-10-13 08:30:00	SPY	ETF	254.99	255.26	254.97	255.13	745565.0
2017-10-13 09:00:00	SPY	ETF	255.13	255.15	255.05	255.145	215012.0
2017-10-13 09:30:00	SPY	ETF	255.14	255.15	254.76	254.91	4017083.0
2017-10-13 10:00:00	SPY	ETF	254.92	255.23	254.915	255.22	3215778.0
2017-10-13 10:30:00	SPY	ETF	255.225	255.27	254.64	255.125	3071734.0
2017-10-13 11:00:00	SPY	ETF	255.125	255.23	255.07	255.09	1678933.0
2017-10-13 11:30:00	SPY	ETF	255.08	255.14	254.94	255.12	1346633.0
2017-10-13 12:00:00	SPY	ETF	255.115	255.2	255.04	255.17	2249655.0
2017-10-13 12:30:00	SPY	ETF	255.18	255.2	255.1	255.165	1774236.0
2017-10-13 13:00:00	SPY	ETF	255.16	255.27	255.15	255.265	1533250.0
2017-10-13 13:30:00	SPY	ETF	255.265	255.27	255.07	255.0775	1341041.0
2017-10-13 14:00:00	SPY	ETF	255.075	255.17	255.01	255.045	1283797.0
2017-10-13 14:30:00	SPY	ETF	255.04	255.1	254.95	255.0607	2128656.0
2017-10-13 15:00:00	SPY	ETF	255.07	255.179	255.02	255.085	2554067.0
2017-10-13 15:30:00	SPY	ETF	255.09	255.1	254.77	254.91	11643041.0
2017-10-13 16:00:00	SPY	ETF	254.91	255.0472	254.8423	255.01	12182929.0
2017-10-13 16:30:00	SPY	ETF	255.0	255.16	254.95	254.98	639327.0
2017-10-13 17:00:00	SPY	ETF	254.98	255.04	254.95	255.04	93027.0
2017-10-13 17:30:00	SPY	ETF	255.04	255.07	254.95	255.02	818216.0
2017-10-13 18:00:00	SPY	ETF	255.05	255.11	255.04	255.04	53417.0
2017-10-13 18:30:00	SPY	ETF	255.05	255.08	254.95	254.96	64923.0
2017-10-13 19:00:00	SPY	ETF	254.96	254.96	254.82	254.87	41435.0
2017-10-13 19:30:00	SPY	ETF	254.88	254.94	254.88	254.91	5113.0
2017-10-13 05:00:00	QQQ	ETF	147.84	147.84	147.83	147.83	200.0
2017-10-13 05:30:00	QQQ	ETF	147.91	147.91	147.91	147.91	100.0
2017-10-13 06:00:00	QQQ	ETF	147.92	148.0	147.91	147.92	26697.0
2017-10-13 06:30:00	QQQ	ETF	147.92	147.94	147.91	147.92	18594.0
2017-10-13 07:00:00	QQQ	ETF	147.96	148.0	147.89	147.92	13934.0
2017-10-13 07:30:00	QQQ	ETF	147.93	148.05	147.93	148.04	42749.0
2017-10-13 08:00:00	QQQ	ETF	147.93	148.14	147.93	148.11	19380.0
2017-10-13 08:30:00	QQQ	ETF	148.13	148.4	148.13	148.3	240474.0
2017-10-13 09:00:00	QQQ	ETF	148.33	148.39	148.28	148.39	105670.0
2017-10-13 09:30:00	QQQ	ETF	148.4	148.4	148.19	148.25	2316972.0
2017-10-13 10:00:00	QQQ	ETF	148.25	148.48	148.25	148.46	994752.0
2017-10-13 10:30:00	QQQ	ETF	148.47	148.5	148.24	148.3	827131.0
2017-10-13 11:00:00	QQQ	ETF	148.305	148.39	148.235	148.31	836310.0
2017-10-13 11:30:00	QQQ	ETF	148.32	148.42	148.25	148.39	389394.0
2017-10-13 12:00:00	QQQ	ETF	148.395	148.455	148.33	148.44	343820.0
2017-10-13 12:30:00	QQQ	ETF	148.44	148.47	148.36	148.43	496410.0
2017-10-13 13:00:00	QQQ	ETF	148.425	148.51	148.42	148.48	706538.0
2017-10-13 13:30:00	QQQ	ETF	148.475	148.49	148.36	148.375	404068.0

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

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