PREVIEW / etf_30min / 2017-10-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-17.parquet
  size:    435 KB
  rows:    15,140

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-17 04:00:00	SPY	ETF	255.22	255.26	255.19	255.19	1800.0
2017-10-17 04:30:00	SPY	ETF	255.25	255.27	255.24	255.24	1900.0
2017-10-17 05:00:00	SPY	ETF	255.22	255.29	255.22	255.29	1200.0
2017-10-17 05:30:00	SPY	ETF	255.32	255.32	255.29	255.29	1420.0
2017-10-17 06:00:00	SPY	ETF	255.32	255.32	255.27	255.27	1320.0
2017-10-17 06:30:00	SPY	ETF	255.24	255.32	255.24	255.29	21704.0
2017-10-17 07:00:00	SPY	ETF	255.3	255.36	255.29	255.36	56965.0
2017-10-17 07:30:00	SPY	ETF	255.39	255.39	255.34	255.36	55699.0
2017-10-17 08:00:00	SPY	ETF	255.36	255.38	255.28	255.31	70296.0
2017-10-17 08:30:00	SPY	ETF	255.28	255.34	255.25	255.3	172207.0
2017-10-17 09:00:00	SPY	ETF	255.3	255.32	255.16	255.23	133128.0
2017-10-17 09:30:00	SPY	ETF	255.23	255.32	255.15	255.28	2670551.0
2017-10-17 10:00:00	SPY	ETF	255.275	255.38	255.15	255.19	2774819.0
2017-10-17 10:30:00	SPY	ETF	255.2	255.21	254.98	255.15	3706216.0
2017-10-17 11:00:00	SPY	ETF	255.15	255.37	255.11	255.31	1765054.0
2017-10-17 11:30:00	SPY	ETF	255.32	255.32	255.09	255.14	1614887.0
2017-10-17 12:00:00	SPY	ETF	255.14	255.23	255.11	255.21	796732.0
2017-10-17 12:30:00	SPY	ETF	255.2	255.235	255.125	255.135	1522317.0
2017-10-17 13:00:00	SPY	ETF	255.135	255.2	255.08	255.09	863892.0
2017-10-17 13:30:00	SPY	ETF	255.095	255.12	255.02	255.1	1329860.0
2017-10-17 14:00:00	SPY	ETF	255.095	255.22	255.09	255.21	1063264.0
2017-10-17 14:30:00	SPY	ETF	255.21	255.3	255.16	255.2792	1317436.0
2017-10-17 15:00:00	SPY	ETF	255.27	255.36	255.24	255.305	1405878.0
2017-10-17 15:30:00	SPY	ETF	255.305	255.52	255.3015	255.46	6692905.0
2017-10-17 16:00:00	SPY	ETF	255.46	255.48	255.18	255.47	2652306.0
2017-10-17 16:30:00	SPY	ETF	255.46	255.46	255.41	255.41	101531.0
2017-10-17 17:00:00	SPY	ETF	255.42	255.43	255.41	255.42	55017.0
2017-10-17 17:30:00	SPY	ETF	255.42	255.42	255.41	255.41	12791.0
2017-10-17 18:00:00	SPY	ETF	255.4	255.41	255.38	255.38	49221.0
2017-10-17 18:30:00	SPY	ETF	255.4	255.42	255.37	255.39	18418.0
2017-10-17 19:00:00	SPY	ETF	255.4	255.4	255.38	255.39	6399.0
2017-10-17 19:30:00	SPY	ETF	255.39	255.57	255.39	255.54	27316.0
2017-10-17 04:00:00	QQQ	ETF	148.86	148.86	148.81	148.81	300.0
2017-10-17 06:00:00	QQQ	ETF	148.87	148.87	148.86	148.86	500.0
2017-10-17 06:30:00	QQQ	ETF	148.89	148.89	148.89	148.89	100.0
2017-10-17 07:00:00	QQQ	ETF	148.91	148.94	148.88	148.94	59328.0
2017-10-17 07:30:00	QQQ	ETF	148.93	148.93	148.91	148.93	33700.0
2017-10-17 08:00:00	QQQ	ETF	148.88	148.95	148.82	148.83	45080.0
2017-10-17 08:30:00	QQQ	ETF	148.83	148.89	148.78	148.89	101510.0
2017-10-17 09:00:00	QQQ	ETF	148.87	148.87	148.74	148.78	167354.0
2017-10-17 09:30:00	QQQ	ETF	148.79	148.83	148.65	148.75	2244669.0
2017-10-17 10:00:00	QQQ	ETF	148.74	148.87	148.58	148.6015	719848.0
2017-10-17 10:30:00	QQQ	ETF	148.6	148.83	148.57	148.79	943974.0
2017-10-17 11:00:00	QQQ	ETF	148.8	148.95	148.76	148.87	1020634.0
2017-10-17 11:30:00	QQQ	ETF	148.88	148.88	148.71	148.74	760495.0
2017-10-17 12:00:00	QQQ	ETF	148.75	148.82	148.71	148.8016	301748.0
2017-10-17 12:30:00	QQQ	ETF	148.81	148.84	148.74	148.77	236623.0
2017-10-17 13:00:00	QQQ	ETF	148.77	148.87	148.76	148.7728	242904.0
2017-10-17 13:30:00	QQQ	ETF	148.78	148.84	148.74	148.77	515547.0
2017-10-17 14:00:00	QQQ	ETF	148.78	148.87	148.78	148.84	413268.0

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

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