PREVIEW / etf_30min / 2017-07-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-17.parquet
  size:    431 KB
  rows:    15,133

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-07-17 04:00:00	SPY	ETF	245.54	245.54	245.51	245.51	8000.0
2017-07-17 04:30:00	SPY	ETF	245.55	245.59	245.53	245.53	5804.0
2017-07-17 05:00:00	SPY	ETF	245.51	245.51	245.33	245.33	3409.0
2017-07-17 05:30:00	SPY	ETF	245.3	245.41	245.3	245.41	3207.0
2017-07-17 06:00:00	SPY	ETF	245.45	245.73	245.45	245.68	22085.0
2017-07-17 06:30:00	SPY	ETF	245.64	245.64	245.6	245.62	24067.0
2017-07-17 07:00:00	SPY	ETF	245.64	245.72	245.59	245.64	91126.0
2017-07-17 07:30:00	SPY	ETF	245.66	245.74	245.65	245.65	27097.0
2017-07-17 08:00:00	SPY	ETF	245.72	245.72	245.6	245.64	61505.0
2017-07-17 08:30:00	SPY	ETF	245.64	245.64	245.44	245.46	194233.0
2017-07-17 09:00:00	SPY	ETF	245.46	245.5	245.4	245.47	128280.0
2017-07-17 09:30:00	SPY	ETF	245.47	245.68	245.33	245.64	3079896.0
2017-07-17 10:00:00	SPY	ETF	245.65	245.77	245.545	245.66	1755345.0
2017-07-17 10:30:00	SPY	ETF	245.6658	245.81	245.49	245.775	2827562.0
2017-07-17 11:00:00	SPY	ETF	245.78	245.87	245.72	245.8	1934442.0
2017-07-17 11:30:00	SPY	ETF	245.8	245.81	245.52	245.63	2013727.0
2017-07-17 12:00:00	SPY	ETF	245.62	245.79	245.595	245.735	951995.0
2017-07-17 12:30:00	SPY	ETF	245.74	245.84	245.69	245.79	829521.0
2017-07-17 13:00:00	SPY	ETF	245.8	245.91	245.74	245.74	1077474.0
2017-07-17 13:30:00	SPY	ETF	245.74	245.8	245.65	245.69	775019.0
2017-07-17 14:00:00	SPY	ETF	245.7	245.73	245.52	245.65	1247764.0
2017-07-17 14:30:00	SPY	ETF	245.6566	245.7	245.52	245.57	1222398.0
2017-07-17 15:00:00	SPY	ETF	245.57	245.62	245.4	245.44	2451732.0
2017-07-17 15:30:00	SPY	ETF	245.44	245.6	245.41	245.51	5248411.0
2017-07-17 16:00:00	SPY	ETF	245.52	245.74	245.5	245.69	4682324.0
2017-07-17 16:30:00	SPY	ETF	245.7	245.82	245.5267	245.82	1992610.0
2017-07-17 17:00:00	SPY	ETF	245.81	245.82	245.5252	245.78	430785.0
2017-07-17 17:30:00	SPY	ETF	245.78	245.81	245.78	245.78	27023.0
2017-07-17 18:00:00	SPY	ETF	245.81	245.81	245.73	245.73	17192.0
2017-07-17 18:30:00	SPY	ETF	245.73	245.76	245.72	245.76	14920.0
2017-07-17 19:00:00	SPY	ETF	245.76	245.78	245.76	245.76	6711.0
2017-07-17 19:30:00	SPY	ETF	245.73	245.78	245.73	245.76	11202.0
2017-07-17 04:00:00	QQQ	ETF	142.37	142.37	142.27	142.27	3775.0
2017-07-17 05:00:00	QQQ	ETF	142.18	142.22	142.17	142.17	1800.0
2017-07-17 05:30:00	QQQ	ETF	142.18	142.22	142.16	142.22	6400.0
2017-07-17 06:00:00	QQQ	ETF	142.35	142.45	142.35	142.45	4810.0
2017-07-17 06:30:00	QQQ	ETF	142.44	142.45	142.4	142.4	3138.0
2017-07-17 07:00:00	QQQ	ETF	142.48	142.49	142.42	142.47	4110.0
2017-07-17 07:30:00	QQQ	ETF	142.47	142.51	142.43	142.43	7452.0
2017-07-17 08:00:00	QQQ	ETF	142.44	142.45	142.38	142.4	15250.0
2017-07-17 08:30:00	QQQ	ETF	142.37	142.38	142.25	142.29	23222.0
2017-07-17 09:00:00	QQQ	ETF	142.25	142.31	142.2	142.27	30427.0
2017-07-17 09:30:00	QQQ	ETF	142.26	142.54	142.14	142.53	2293830.0
2017-07-17 10:00:00	QQQ	ETF	142.53	142.69	142.37	142.4	2058873.0
2017-07-17 10:30:00	QQQ	ETF	142.405	142.445	142.1399	142.17	1825495.0
2017-07-17 11:00:00	QQQ	ETF	142.18	142.255	142.02	142.2	1488919.0
2017-07-17 11:30:00	QQQ	ETF	142.21	142.25	142.06	142.115	1182644.0
2017-07-17 12:00:00	QQQ	ETF	142.11	142.29	142.07	142.24	885024.0
2017-07-17 12:30:00	QQQ	ETF	142.25	142.36	142.2	142.32	513638.0
2017-07-17 13:00:00	QQQ	ETF	142.319	142.37	142.25	142.25	868571.0

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

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