PREVIEW / etf_30min / 2017-08-29

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-29.parquet
  size:    439 KB
  rows:    15,096

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-08-29 04:00:00	SPY	ETF	242.73	242.87	242.46	242.65	39714.0
2017-08-29 04:30:00	SPY	ETF	242.66	242.73	242.59	242.64	7205.0
2017-08-29 05:00:00	SPY	ETF	242.5	242.74	242.43	242.73	9491.0
2017-08-29 05:30:00	SPY	ETF	242.79	243.04	242.79	242.95	12774.0
2017-08-29 06:00:00	SPY	ETF	242.93	243.0	242.78	242.95	18063.0
2017-08-29 06:30:00	SPY	ETF	242.95	243.09	242.92	243.09	28189.0
2017-08-29 07:00:00	SPY	ETF	243.14	243.42	243.14	243.29	111772.0
2017-08-29 07:30:00	SPY	ETF	243.34	243.52	243.32	243.43	252921.0
2017-08-29 08:00:00	SPY	ETF	243.43	243.53	243.25	243.37	379810.0
2017-08-29 08:30:00	SPY	ETF	243.35	243.41	243.11	243.26	426424.0
2017-08-29 09:00:00	SPY	ETF	243.25	243.27	243.05	243.1	826163.0
2017-08-29 09:30:00	SPY	ETF	243.06	243.85	242.93	243.8	8110665.0
2017-08-29 10:00:00	SPY	ETF	243.8	243.88	243.47	243.8101	4944713.0
2017-08-29 10:30:00	SPY	ETF	243.81	244.33	243.8	244.22	4886778.0
2017-08-29 11:00:00	SPY	ETF	244.21	244.48	244.13	244.21	3630856.0
2017-08-29 11:30:00	SPY	ETF	244.21	244.57	244.15	244.4	2925629.0
2017-08-29 12:00:00	SPY	ETF	244.4	244.53	244.32	244.49	2594000.0
2017-08-29 12:30:00	SPY	ETF	244.5	244.7	244.465	244.575	3408628.0
2017-08-29 13:00:00	SPY	ETF	244.58	244.74	244.42	244.7	1843977.0
2017-08-29 13:30:00	SPY	ETF	244.69	244.76	244.53	244.63	1776302.0
2017-08-29 14:00:00	SPY	ETF	244.63	244.73	244.57	244.625	1054358.0
2017-08-29 14:30:00	SPY	ETF	244.625	244.95	244.61	244.92	1763594.0
2017-08-29 15:00:00	SPY	ETF	244.92	245.15	244.83	245.065	2868712.0
2017-08-29 15:30:00	SPY	ETF	245.06	245.11	244.8	244.85	5378313.0
2017-08-29 16:00:00	SPY	ETF	244.84	245.08	244.82	245.04	2620875.0
2017-08-29 16:30:00	SPY	ETF	245.04	245.04	244.6462	245.0	379770.0
2017-08-29 17:00:00	SPY	ETF	244.98	244.99	244.88	244.88	94763.0
2017-08-29 17:30:00	SPY	ETF	244.88	244.93	244.86	244.93	76190.0
2017-08-29 18:00:00	SPY	ETF	244.93	244.95	244.82	244.83	95881.0
2017-08-29 18:30:00	SPY	ETF	244.85	244.89	244.83	244.88	4111.0
2017-08-29 19:00:00	SPY	ETF	244.89	245.2	244.89	245.11	69705.0
2017-08-29 19:30:00	SPY	ETF	245.11	245.16	245.08	245.15	32236.0
2017-08-29 04:00:00	QQQ	ETF	141.2	141.25	140.92	141.03	74750.0
2017-08-29 04:30:00	QQQ	ETF	141.05	141.08	140.95	141.0	2995.0
2017-08-29 05:00:00	QQQ	ETF	140.97	141.05	140.85	141.05	15392.0
2017-08-29 05:30:00	QQQ	ETF	141.1	141.26	141.07	141.23	14094.0
2017-08-29 06:00:00	QQQ	ETF	141.23	141.23	141.15	141.15	2400.0
2017-08-29 06:30:00	QQQ	ETF	141.24	141.31	141.21	141.31	4099.0
2017-08-29 07:00:00	QQQ	ETF	141.35	141.45	141.32	141.32	30478.0
2017-08-29 07:30:00	QQQ	ETF	141.33	141.49	141.33	141.45	84722.0
2017-08-29 08:00:00	QQQ	ETF	141.43	141.51	141.35	141.38	92493.0
2017-08-29 08:30:00	QQQ	ETF	141.37	141.41	141.21	141.32	170815.0
2017-08-29 09:00:00	QQQ	ETF	141.27	141.35	141.18	141.19	336841.0
2017-08-29 09:30:00	QQQ	ETF	141.19	141.98	141.06	141.92	5043486.0
2017-08-29 10:00:00	QQQ	ETF	141.92	142.15	141.76	142.13	2187675.0
2017-08-29 10:30:00	QQQ	ETF	142.13	142.53	142.13	142.4	3010234.0
2017-08-29 11:00:00	QQQ	ETF	142.39	142.69	142.36	142.5599	881055.0
2017-08-29 11:30:00	QQQ	ETF	142.55	142.91	142.53	142.795	1051533.0
2017-08-29 12:00:00	QQQ	ETF	142.79	142.84	142.72	142.795	376063.0
2017-08-29 12:30:00	QQQ	ETF	142.79	142.94	142.74	142.81	464487.0

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

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