PREVIEW / etf_30min / 2017-10-16

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-16.parquet
  size:    437 KB
  rows:    15,247

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-16 04:00:00	SPY	ETF	255.05	255.08	255.05	255.05	3200.0
2017-10-16 04:30:00	SPY	ETF	255.09	255.1	255.05	255.05	3700.0
2017-10-16 05:00:00	SPY	ETF	255.08	255.08	255.08	255.08	530.0
2017-10-16 05:30:00	SPY	ETF	255.08	255.14	255.08	255.14	4800.0
2017-10-16 06:00:00	SPY	ETF	255.12	255.14	255.11	255.14	3100.0
2017-10-16 06:30:00	SPY	ETF	255.14	255.15	255.14	255.15	7000.0
2017-10-16 07:00:00	SPY	ETF	255.1	255.1	254.99	254.99	11921.0
2017-10-16 07:30:00	SPY	ETF	255.02	255.12	255.02	255.05	200272.0
2017-10-16 08:00:00	SPY	ETF	255.05	255.26	255.02	255.2	897946.0
2017-10-16 08:30:00	SPY	ETF	255.21	255.23	254.95	255.18	45906.0
2017-10-16 09:00:00	SPY	ETF	255.16	255.28	255.11	255.22	192384.0
2017-10-16 09:30:00	SPY	ETF	255.21	255.51	255.2	255.37	4048168.0
2017-10-16 10:00:00	SPY	ETF	255.37	255.42	254.945	255.1	3025657.0
2017-10-16 10:30:00	SPY	ETF	255.1	255.115	254.93	254.99	1563970.0
2017-10-16 11:00:00	SPY	ETF	254.995	255.22	254.97	255.21	2091400.0
2017-10-16 11:30:00	SPY	ETF	255.21	255.21	255.05	255.06	2855900.0
2017-10-16 12:00:00	SPY	ETF	255.06	255.085	254.82	254.9367	1620975.0
2017-10-16 12:30:00	SPY	ETF	254.94	255.05	254.92	254.98	1520762.0
2017-10-16 13:00:00	SPY	ETF	254.98	255.13	254.94	255.12	1525653.0
2017-10-16 13:30:00	SPY	ETF	255.12	255.18	255.02	255.02	1360404.0
2017-10-16 14:00:00	SPY	ETF	255.02	255.17	255.01	255.16	1505252.0
2017-10-16 14:30:00	SPY	ETF	255.15	255.16	255.06	255.1183	1121748.0
2017-10-16 15:00:00	SPY	ETF	255.115	255.22	255.08	255.16	1562850.0
2017-10-16 15:30:00	SPY	ETF	255.16	255.34	255.14	255.3	6364231.0
2017-10-16 16:00:00	SPY	ETF	255.3	255.41	255.22	255.34	5192285.0
2017-10-16 16:30:00	SPY	ETF	255.36	255.36	255.29	255.31	173289.0
2017-10-16 17:00:00	SPY	ETF	255.3	255.3	255.18	255.24	67830.0
2017-10-16 17:30:00	SPY	ETF	255.23	255.27	255.23	255.25	53770.0
2017-10-16 18:00:00	SPY	ETF	255.27	255.29	255.25	255.26	22093.0
2017-10-16 18:30:00	SPY	ETF	255.27	255.29	255.27	255.28	4400.0
2017-10-16 19:00:00	SPY	ETF	255.27	255.3	255.27	255.28	10200.0
2017-10-16 19:30:00	SPY	ETF	255.3	255.32	255.29	255.3	51987.0
2017-10-16 04:00:00	QQQ	ETF	148.65	148.69	148.61	148.61	4170.0
2017-10-16 04:30:00	QQQ	ETF	148.61	148.62	148.61	148.61	6220.0
2017-10-16 05:00:00	QQQ	ETF	148.62	148.64	148.62	148.64	1100.0
2017-10-16 05:30:00	QQQ	ETF	148.59	148.59	148.59	148.59	100.0
2017-10-16 06:30:00	QQQ	ETF	148.63	148.64	148.62	148.64	10500.0
2017-10-16 07:00:00	QQQ	ETF	148.61	148.61	148.53	148.53	5927.0
2017-10-16 07:30:00	QQQ	ETF	148.54	148.63	148.54	148.62	33767.0
2017-10-16 08:00:00	QQQ	ETF	148.61	148.7	148.55	148.67	49037.0
2017-10-16 08:30:00	QQQ	ETF	148.69	148.72	148.66	148.71	17800.0
2017-10-16 09:00:00	QQQ	ETF	148.67	148.76	148.67	148.69	37230.0
2017-10-16 09:30:00	QQQ	ETF	148.7	148.89	148.67	148.82	3647857.0
2017-10-16 10:00:00	QQQ	ETF	148.83	148.88	148.53	148.66	2710316.0
2017-10-16 10:30:00	QQQ	ETF	148.67	148.72	148.59	148.69	758834.0
2017-10-16 11:00:00	QQQ	ETF	148.69	148.77	148.58	148.729	832458.0
2017-10-16 11:30:00	QQQ	ETF	148.73	148.78	148.69	148.69	432264.0
2017-10-16 12:00:00	QQQ	ETF	148.7	148.74	148.3928	148.5	1582724.0
2017-10-16 12:30:00	QQQ	ETF	148.51	148.619	148.49	148.57	544867.0
2017-10-16 13:00:00	QQQ	ETF	148.58	148.64	148.495	148.64	473028.0

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

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