PREVIEW / etf_30min / 2017-10-30

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-30.parquet
  size:    444 KB
  rows:    15,518

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-30 04:00:00	SPY	ETF	257.25	257.3	257.16	257.24	11060.0
2017-10-30 04:30:00	SPY	ETF	257.24	257.3	257.21	257.21	2173.0
2017-10-30 05:00:00	SPY	ETF	257.27	257.34	257.25	257.34	8377.0
2017-10-30 05:30:00	SPY	ETF	257.23	257.27	257.2	257.24	8700.0
2017-10-30 06:00:00	SPY	ETF	257.21	257.24	257.14	257.14	25077.0
2017-10-30 06:30:00	SPY	ETF	257.12	257.15	257.05	257.05	15570.0
2017-10-30 07:00:00	SPY	ETF	257.03	257.1	257.02	257.07	57585.0
2017-10-30 07:30:00	SPY	ETF	257.05	257.19	257.05	257.19	106230.0
2017-10-30 08:00:00	SPY	ETF	257.09	257.21	257.06	257.15	81369.0
2017-10-30 08:30:00	SPY	ETF	257.14	257.19	257.06	257.11	97980.0
2017-10-30 09:00:00	SPY	ETF	257.11	257.22	257.07	257.09	317317.0
2017-10-30 09:30:00	SPY	ETF	257.07	257.4	256.99	257.27	4541678.0
2017-10-30 10:00:00	SPY	ETF	257.2799	257.4999	257.21	257.465	2602410.0
2017-10-30 10:30:00	SPY	ETF	257.47	257.6	257.43	257.47	1731771.0
2017-10-30 11:00:00	SPY	ETF	257.47	257.505	257.04	257.0525	2468820.0
2017-10-30 11:30:00	SPY	ETF	257.055	257.12	256.64	256.89	4868363.0
2017-10-30 12:00:00	SPY	ETF	256.88	256.9	256.41	256.64	2923796.0
2017-10-30 12:30:00	SPY	ETF	256.64	256.85	256.64	256.81	4691346.0
2017-10-30 13:00:00	SPY	ETF	256.8	257.0	256.785	256.97	1963821.0
2017-10-30 13:30:00	SPY	ETF	256.9662	257.01	256.65	256.7	2638193.0
2017-10-30 14:00:00	SPY	ETF	256.71	256.97	256.65	256.86	2359134.0
2017-10-30 14:30:00	SPY	ETF	256.86	256.98	256.75	256.87	1590615.0
2017-10-30 15:00:00	SPY	ETF	256.87	256.9	256.555	256.72	2880798.0
2017-10-30 15:30:00	SPY	ETF	256.72	257.06	256.66	256.8	7731172.0
2017-10-30 16:00:00	SPY	ETF	256.81	256.9	256.65	256.67	7999644.0
2017-10-30 16:30:00	SPY	ETF	256.69	256.75	256.63	256.68	683854.0
2017-10-30 17:00:00	SPY	ETF	256.66	256.66	256.65	256.65	14100.0
2017-10-30 17:30:00	SPY	ETF	256.69	256.69	256.65	256.68	2500.0
2017-10-30 18:00:00	SPY	ETF	256.65	256.72	256.6	256.68	33483.0
2017-10-30 18:30:00	SPY	ETF	256.64	256.64	256.63	256.64	13145.0
2017-10-30 19:00:00	SPY	ETF	256.63	256.71	256.63	256.7	1473.0
2017-10-30 19:30:00	SPY	ETF	256.69	256.7	256.56	256.58	11526.0
2017-10-30 04:00:00	QQQ	ETF	151.33	151.33	151.21	151.27	13800.0
2017-10-30 04:30:00	QQQ	ETF	151.28	151.28	151.22	151.22	600.0
2017-10-30 05:00:00	QQQ	ETF	151.27	151.32	151.27	151.32	600.0
2017-10-30 05:30:00	QQQ	ETF	151.26	151.32	151.26	151.32	1700.0
2017-10-30 06:00:00	QQQ	ETF	151.33	151.35	151.24	151.24	4500.0
2017-10-30 06:30:00	QQQ	ETF	151.25	151.26	151.2	151.2	1600.0
2017-10-30 07:00:00	QQQ	ETF	151.18	151.23	151.16	151.19	5505.0
2017-10-30 07:30:00	QQQ	ETF	151.21	151.27	151.21	151.24	49292.0
2017-10-30 08:00:00	QQQ	ETF	151.18	151.28	151.17	151.2	25629.0
2017-10-30 08:30:00	QQQ	ETF	151.21	151.34	151.21	151.26	55305.0
2017-10-30 09:00:00	QQQ	ETF	151.24	151.29	151.09	151.1	216739.0
2017-10-30 09:30:00	QQQ	ETF	151.08	151.78	151.07	151.74	3070104.0
2017-10-30 10:00:00	QQQ	ETF	151.73	152.165	151.67	152.08	2719756.0
2017-10-30 10:30:00	QQQ	ETF	152.09	152.19	151.86	151.955	1478231.0
2017-10-30 11:00:00	QQQ	ETF	151.95	151.975	151.51	151.535	1880180.0
2017-10-30 11:30:00	QQQ	ETF	151.535	151.59	151.29	151.56	2452023.0
2017-10-30 12:00:00	QQQ	ETF	151.54	151.559	150.9899	151.2	3061435.0
2017-10-30 12:30:00	QQQ	ETF	151.205	151.46	151.19	151.449	1319771.0

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

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