PREVIEW / etf_30min / 2017-10-24

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-24.parquet
  size:    443 KB
  rows:    15,454

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-24 04:00:00	SPY	ETF	256.25	256.25	256.19	256.19	1600.0
2017-10-24 04:30:00	SPY	ETF	256.22	256.26	256.1	256.21	5389.0
2017-10-24 05:00:00	SPY	ETF	256.29	256.36	256.25	256.36	7806.0
2017-10-24 05:30:00	SPY	ETF	256.34	256.41	256.34	256.41	6312.0
2017-10-24 06:00:00	SPY	ETF	256.39	256.44	256.39	256.44	16809.0
2017-10-24 06:30:00	SPY	ETF	256.46	256.54	256.41	256.42	7349.0
2017-10-24 07:00:00	SPY	ETF	256.44	256.49	256.37	256.48	102689.0
2017-10-24 07:30:00	SPY	ETF	256.51	256.69	256.5	256.57	141541.0
2017-10-24 08:00:00	SPY	ETF	256.55	256.67	256.47	256.6	309111.0
2017-10-24 08:30:00	SPY	ETF	256.61	256.72	256.6	256.65	205566.0
2017-10-24 09:00:00	SPY	ETF	256.62	256.67	256.56	256.58	260389.0
2017-10-24 09:30:00	SPY	ETF	256.6	256.74	256.15	256.16	5316002.0
2017-10-24 10:00:00	SPY	ETF	256.165	256.47	256.15	256.4389	5769877.0
2017-10-24 10:30:00	SPY	ETF	256.43	256.55	256.31	256.48	4906471.0
2017-10-24 11:00:00	SPY	ETF	256.47	256.62	256.47	256.58	4635773.0
2017-10-24 11:30:00	SPY	ETF	256.58	256.69	256.51	256.6099	2816067.0
2017-10-24 12:00:00	SPY	ETF	256.61	256.68	256.545	256.605	1697740.0
2017-10-24 12:30:00	SPY	ETF	256.6	256.67	256.58	256.585	2703993.0
2017-10-24 13:00:00	SPY	ETF	256.59	256.65	256.51	256.6	3006911.0
2017-10-24 13:30:00	SPY	ETF	256.6	256.71	256.57	256.64	1565327.0
2017-10-24 14:00:00	SPY	ETF	256.65	256.83	256.59	256.78	1648257.0
2017-10-24 14:30:00	SPY	ETF	256.78	256.82	256.51	256.58	4185386.0
2017-10-24 15:00:00	SPY	ETF	256.59	256.675	256.27	256.385	5655356.0
2017-10-24 15:30:00	SPY	ETF	256.38	256.59	256.32	256.55	9012818.0
2017-10-24 16:00:00	SPY	ETF	256.53	256.57	256.47	256.48	6892063.0
2017-10-24 16:30:00	SPY	ETF	256.48	256.48	256.26	256.3	279127.0
2017-10-24 17:00:00	SPY	ETF	256.31	256.4	256.3	256.36	70701.0
2017-10-24 17:30:00	SPY	ETF	256.36	256.36	256.32	256.32	60118.0
2017-10-24 18:00:00	SPY	ETF	256.32	256.4979	256.19	256.25	1797587.0
2017-10-24 18:30:00	SPY	ETF	256.25	256.29	256.21	256.21	24248.0
2017-10-24 19:00:00	SPY	ETF	256.22	256.22	256.15	256.18	10319.0
2017-10-24 19:30:00	SPY	ETF	256.2	256.3	256.2	256.3	7381.0
2017-10-24 04:00:00	QQQ	ETF	147.7	147.7	147.7	147.7	5000.0
2017-10-24 04:30:00	QQQ	ETF	147.7	147.7	147.7	147.7	5000.0
2017-10-24 05:00:00	QQQ	ETF	147.76	147.84	147.76	147.84	1200.0
2017-10-24 05:30:00	QQQ	ETF	147.82	147.83	147.75	147.76	21697.0
2017-10-24 06:00:00	QQQ	ETF	147.75	147.84	147.75	147.84	4397.0
2017-10-24 06:30:00	QQQ	ETF	147.84	147.88	147.78	147.78	4999.0
2017-10-24 07:00:00	QQQ	ETF	147.81	147.87	147.81	147.85	6025.0
2017-10-24 07:30:00	QQQ	ETF	147.88	147.91	147.76	147.83	41788.0
2017-10-24 08:00:00	QQQ	ETF	147.84	147.91	147.83	147.91	54735.0
2017-10-24 08:30:00	QQQ	ETF	147.91	148.08	147.91	148.02	170833.0
2017-10-24 09:00:00	QQQ	ETF	148.01	148.06	147.98	147.99	46772.0
2017-10-24 09:30:00	QQQ	ETF	148.0	148.04	147.44	147.54	3322464.0
2017-10-24 10:00:00	QQQ	ETF	147.55	147.9401	147.53	147.9245	1184059.0
2017-10-24 10:30:00	QQQ	ETF	147.92	148.08	147.88	147.99	786502.0
2017-10-24 11:00:00	QQQ	ETF	147.994	148.18	147.98	148.11	985038.0
2017-10-24 11:30:00	QQQ	ETF	148.12	148.21	148.065	148.12	473331.0
2017-10-24 12:00:00	QQQ	ETF	148.11	148.15	148.06	148.11	534839.0
2017-10-24 12:30:00	QQQ	ETF	148.1	148.17	148.02	148.0301	423924.0

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

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