PREVIEW / etf_30min / 2017-11-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-01.parquet
  size:    457 KB
  rows:    15,832

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-11-01 04:00:00	SPY	ETF	257.6	257.91	257.6	257.9	16464.0
2017-11-01 04:30:00	SPY	ETF	257.92	257.94	257.86	257.94	27460.0
2017-11-01 05:00:00	SPY	ETF	257.96	258.01	257.95	257.96	10410.0
2017-11-01 05:30:00	SPY	ETF	258.0	258.07	258.0	258.07	2105.0
2017-11-01 06:00:00	SPY	ETF	258.21	258.31	258.2	258.31	3661.0
2017-11-01 06:30:00	SPY	ETF	258.24	258.28	258.22	258.22	4002.0
2017-11-01 07:00:00	SPY	ETF	258.22	258.28	258.16	258.18	103691.0
2017-11-01 07:30:00	SPY	ETF	258.18	258.2	258.06	258.1	46007.0
2017-11-01 08:00:00	SPY	ETF	257.15	258.22	257.15	258.16	137916.0
2017-11-01 08:30:00	SPY	ETF	258.15	258.15	258.08	258.11	106495.0
2017-11-01 09:00:00	SPY	ETF	258.07	258.11	258.02	258.06	315257.0
2017-11-01 09:30:00	SPY	ETF	258.04	258.43	257.925	258.29	6500599.0
2017-11-01 10:00:00	SPY	ETF	258.29	258.31	258.02	258.0285	3716001.0
2017-11-01 10:30:00	SPY	ETF	258.02	258.16	257.79	257.93	5812916.0
2017-11-01 11:00:00	SPY	ETF	257.93	258.04	257.86	257.865	2577021.0
2017-11-01 11:30:00	SPY	ETF	257.865	257.95	257.43	257.53	4578162.0
2017-11-01 12:00:00	SPY	ETF	257.53	257.78	257.5	257.715	2493426.0
2017-11-01 12:30:00	SPY	ETF	257.715	257.76	257.53	257.575	1637694.0
2017-11-01 13:00:00	SPY	ETF	257.57	257.57	257.07	257.365	3309637.0
2017-11-01 13:30:00	SPY	ETF	257.369	257.49	257.21	257.42	1990192.0
2017-11-01 14:00:00	SPY	ETF	257.44	257.695	257.37	257.42	2633303.0
2017-11-01 14:30:00	SPY	ETF	257.42	257.75	257.41	257.66	2380765.0
2017-11-01 15:00:00	SPY	ETF	257.66	257.74	257.49	257.65	3211017.0
2017-11-01 15:30:00	SPY	ETF	257.65	257.76	257.42	257.51	6503750.0
2017-11-01 16:00:00	SPY	ETF	257.53	257.5742	257.31	257.39	3930510.0
2017-11-01 16:30:00	SPY	ETF	257.38	257.5413	257.16	257.18	896093.0
2017-11-01 17:00:00	SPY	ETF	257.18	257.49	256.97	257.14	285046.0
2017-11-01 17:30:00	SPY	ETF	257.13	257.14	257.07	257.09	47463.0
2017-11-01 18:00:00	SPY	ETF	257.09	257.23	257.08	257.19	19674.0
2017-11-01 18:30:00	SPY	ETF	257.21	257.24	257.19	257.19	18786.0
2017-11-01 19:00:00	SPY	ETF	257.19	257.19	257.16	257.19	3902.0
2017-11-01 19:30:00	SPY	ETF	257.24	257.3	257.24	257.26	20189.0
2017-11-01 04:00:00	QQQ	ETF	152.56	152.84	152.56	152.73	8700.0
2017-11-01 04:30:00	QQQ	ETF	152.74	152.81	152.74	152.81	3250.0
2017-11-01 05:00:00	QQQ	ETF	152.82	152.82	152.82	152.82	466.0
2017-11-01 05:30:00	QQQ	ETF	152.83	152.87	152.83	152.87	1608.0
2017-11-01 06:00:00	QQQ	ETF	152.93	153.0	152.93	152.96	2117.0
2017-11-01 06:30:00	QQQ	ETF	152.94	152.94	152.82	152.84	2855.0
2017-11-01 07:00:00	QQQ	ETF	152.81	152.9	152.74	152.86	96380.0
2017-11-01 07:30:00	QQQ	ETF	152.85	152.88	152.74	152.8	28185.0
2017-11-01 08:00:00	QQQ	ETF	152.75	152.86	152.75	152.82	23470.0
2017-11-01 08:30:00	QQQ	ETF	152.82	152.82	152.72	152.76	47698.0
2017-11-01 09:00:00	QQQ	ETF	152.72	152.78	152.69	152.74	61407.0
2017-11-01 09:30:00	QQQ	ETF	152.75	152.83	152.38	152.5199	2795024.0
2017-11-01 10:00:00	QQQ	ETF	152.5	152.58	152.18	152.33	2221039.0
2017-11-01 10:30:00	QQQ	ETF	152.33	152.39	152.115	152.16	1802246.0
2017-11-01 11:00:00	QQQ	ETF	152.17	152.45	152.13	152.32	564342.0
2017-11-01 11:30:00	QQQ	ETF	152.315	152.395	151.95	151.98	1349154.0
2017-11-01 12:00:00	QQQ	ETF	151.99	152.27	151.98	152.27	719132.0
2017-11-01 12:30:00	QQQ	ETF	152.27	152.29	152.03	152.09	938688.0

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

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