PREVIEW / etf_30min / 2017-04-24

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-24.parquet
  size:    438 KB
  rows:    15,191

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-04-24 04:00:00	SPY	ETF	237.06	237.32	237.06	237.2	25627.0
2017-04-24 04:30:00	SPY	ETF	237.22	237.36	237.19	237.36	9838.0
2017-04-24 05:00:00	SPY	ETF	237.36	237.47	237.25	237.4	21666.0
2017-04-24 05:30:00	SPY	ETF	237.4	237.44	237.3	237.41	5839.0
2017-04-24 06:00:00	SPY	ETF	237.39	237.71	237.39	237.59	43775.0
2017-04-24 06:30:00	SPY	ETF	237.56	237.6	237.47	237.54	58188.0
2017-04-24 07:00:00	SPY	ETF	237.47	237.5	237.3	237.42	171984.0
2017-04-24 07:30:00	SPY	ETF	237.41	237.47	237.26	237.42	380875.0
2017-04-24 08:00:00	SPY	ETF	237.42	237.51	234.59	237.48	496855.0
2017-04-24 08:30:00	SPY	ETF	237.46	237.52	234.59	237.3	747525.0
2017-04-24 09:00:00	SPY	ETF	237.31	237.31	236.99	237.19	580360.0
2017-04-24 09:30:00	SPY	ETF	237.18	237.28	236.74	236.995	11519661.0
2017-04-24 10:00:00	SPY	ETF	237.0	237.22	236.91	237.0958	7700648.0
2017-04-24 10:30:00	SPY	ETF	237.09	237.17	236.81	236.97	10395324.0
2017-04-24 11:00:00	SPY	ETF	236.97	237.05	236.61	236.74	7876003.0
2017-04-24 11:30:00	SPY	ETF	236.74	236.85	236.61	236.65	3874672.0
2017-04-24 12:00:00	SPY	ETF	236.655	236.96	236.655	236.8589	5020963.0
2017-04-24 12:30:00	SPY	ETF	236.855	236.95	236.77	236.87	4411062.0
2017-04-24 13:00:00	SPY	ETF	236.86	237.11	236.85	237.09	7769774.0
2017-04-24 13:30:00	SPY	ETF	237.085	237.12	236.95	237.08	6369354.0
2017-04-24 14:00:00	SPY	ETF	237.08	237.32	236.97	237.2199	5543086.0
2017-04-24 14:30:00	SPY	ETF	237.22	237.32	237.08	237.15	3428877.0
2017-04-24 15:00:00	SPY	ETF	237.15	237.41	237.14	237.26	9841163.0
2017-04-24 15:30:00	SPY	ETF	237.26	237.33	237.05	237.12	14760282.0
2017-04-24 16:00:00	SPY	ETF	237.12	237.17	236.88	237.13	12305723.0
2017-04-24 16:30:00	SPY	ETF	237.13	237.13	237.06	237.07	294097.0
2017-04-24 17:00:00	SPY	ETF	237.06	237.3206	237.06	237.09	327905.0
2017-04-24 17:30:00	SPY	ETF	237.11	237.11	237.08	237.08	13701.0
2017-04-24 18:00:00	SPY	ETF	237.08	237.08	236.9	236.95	111212.0
2017-04-24 18:30:00	SPY	ETF	236.95	237.03	236.95	237.0	25667.0
2017-04-24 19:00:00	SPY	ETF	237.0	237.0	236.96	236.98	12843.0
2017-04-24 19:30:00	SPY	ETF	236.98	237.0	236.88	236.94	38316.0
2017-04-24 04:00:00	QQQ	ETF	133.79	133.91	133.1	133.9	3104.0
2017-04-24 04:30:00	QQQ	ETF	133.92	134.0	133.92	134.0	4015.0
2017-04-24 05:00:00	QQQ	ETF	134.01	134.01	134.01	134.01	700.0
2017-04-24 06:00:00	QQQ	ETF	133.95	134.06	133.94	134.06	945.0
2017-04-24 06:30:00	QQQ	ETF	134.02	134.02	134.01	134.01	2388.0
2017-04-24 07:00:00	QQQ	ETF	133.96	133.98	133.93	133.97	21600.0
2017-04-24 07:30:00	QQQ	ETF	133.98	134.02	133.91	133.98	39727.0
2017-04-24 08:00:00	QQQ	ETF	133.97	134.11	133.75	134.1	199254.0
2017-04-24 08:30:00	QQQ	ETF	134.1	134.14	134.01	134.02	38567.0
2017-04-24 09:00:00	QQQ	ETF	134.06	134.06	133.94	134.01	147751.0
2017-04-24 09:30:00	QQQ	ETF	134.02	134.12	133.8042	134.08	4094069.0
2017-04-24 10:00:00	QQQ	ETF	134.08	134.21	133.9531	134.12	1792407.0
2017-04-24 10:30:00	QQQ	ETF	134.121	134.14	133.98	134.06	995276.0
2017-04-24 11:00:00	QQQ	ETF	134.06	134.085	133.85	133.9299	1184591.0
2017-04-24 11:30:00	QQQ	ETF	133.925	133.97	133.84	133.87	727416.0
2017-04-24 12:00:00	QQQ	ETF	133.88	134.04	133.88	133.97	787782.0
2017-04-24 12:30:00	QQQ	ETF	133.97	134.01	133.91	133.97	671778.0
2017-04-24 13:00:00	QQQ	ETF	133.97	134.0765	133.96	134.05	1080371.0

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

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