PREVIEW / etf_30min / 2017-10-04

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-04.parquet
  size:    436 KB
  rows:    15,131

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-04 04:00:00	SPY	ETF	252.77	252.77	252.77	252.77	100.0
2017-10-04 04:30:00	SPY	ETF	252.87	252.87	252.84	252.84	4200.0
2017-10-04 05:00:00	SPY	ETF	252.84	252.84	252.82	252.82	500.0
2017-10-04 05:30:00	SPY	ETF	252.81	252.81	252.77	252.78	16400.0
2017-10-04 06:00:00	SPY	ETF	252.78	252.78	252.76	252.77	5100.0
2017-10-04 06:30:00	SPY	ETF	252.78	252.78	252.7	252.7	11804.0
2017-10-04 07:00:00	SPY	ETF	252.76	252.81	252.75	252.8	34898.0
2017-10-04 07:30:00	SPY	ETF	252.8	252.8	252.66	252.78	22452.0
2017-10-04 08:00:00	SPY	ETF	252.82	252.82	252.62	252.62	71496.0
2017-10-04 08:30:00	SPY	ETF	252.66	252.68	252.62	252.66	50893.0
2017-10-04 09:00:00	SPY	ETF	252.66	252.78	252.66	252.7	2505957.0
2017-10-04 09:30:00	SPY	ETF	252.69	252.9	252.56	252.81	4473763.0
2017-10-04 10:00:00	SPY	ETF	252.81	252.86	252.71	252.82	2488624.0
2017-10-04 10:30:00	SPY	ETF	252.81	252.89	252.68	252.88	3598352.0
2017-10-04 11:00:00	SPY	ETF	252.88	253.1	252.8792	253.0856	2168989.0
2017-10-04 11:30:00	SPY	ETF	253.085	253.3	253.02	253.27	2087917.0
2017-10-04 12:00:00	SPY	ETF	253.27	253.44	253.22	253.36	3122655.0
2017-10-04 12:30:00	SPY	ETF	253.36	253.36	253.17	253.24	2168807.0
2017-10-04 13:00:00	SPY	ETF	253.23	253.32	253.13	253.225	1480836.0
2017-10-04 13:30:00	SPY	ETF	253.23	253.23	252.91	253.09	2347813.0
2017-10-04 14:00:00	SPY	ETF	253.085	253.17	253.0	253.05	1995592.0
2017-10-04 14:30:00	SPY	ETF	253.05	253.18	252.99	253.16	1954319.0
2017-10-04 15:00:00	SPY	ETF	253.15	253.265	253.13	253.175	2703298.0
2017-10-04 15:30:00	SPY	ETF	253.17	253.215	252.98	253.16	8033302.0
2017-10-04 16:00:00	SPY	ETF	253.16	253.26	253.11	253.1468	8348772.0
2017-10-04 16:30:00	SPY	ETF	253.22	253.27	253.18	253.19	280670.0
2017-10-04 17:00:00	SPY	ETF	253.22	253.23	253.16	253.16	5206148.0
2017-10-04 17:30:00	SPY	ETF	253.22	253.25	253.2	253.2	20255.0
2017-10-04 18:00:00	SPY	ETF	253.2	253.2	253.15	253.16	58302.0
2017-10-04 18:30:00	SPY	ETF	253.13	253.21	253.13	253.21	12448.0
2017-10-04 19:00:00	SPY	ETF	253.18	253.18	253.14	253.16	49739.0
2017-10-04 19:30:00	SPY	ETF	253.17	253.19	253.16	253.16	28592.0
2017-10-04 04:00:00	QQQ	ETF	145.8	145.87	145.8	145.84	2573.0
2017-10-04 04:30:00	QQQ	ETF	145.84	145.84	145.81	145.81	2700.0
2017-10-04 05:00:00	QQQ	ETF	145.78	145.78	145.78	145.78	200.0
2017-10-04 05:30:00	QQQ	ETF	145.77	145.77	145.76	145.76	2000.0
2017-10-04 06:00:00	QQQ	ETF	145.75	145.75	145.71	145.71	1150.0
2017-10-04 06:30:00	QQQ	ETF	145.78	145.78	145.67	145.67	11368.0
2017-10-04 07:00:00	QQQ	ETF	145.75	145.8	145.73	145.74	14534.0
2017-10-04 07:30:00	QQQ	ETF	145.75	145.75	145.66	145.69	61097.0
2017-10-04 08:00:00	QQQ	ETF	145.677	145.77	145.54	145.58	104989.0
2017-10-04 08:30:00	QQQ	ETF	145.58	145.65	145.57	145.63	71001.0
2017-10-04 09:00:00	QQQ	ETF	145.61	145.68	145.59	145.63	78767.0
2017-10-04 09:30:00	QQQ	ETF	145.6	145.88	145.47	145.73	3698345.0
2017-10-04 10:00:00	QQQ	ETF	145.74	145.851	145.62	145.71	2452896.0
2017-10-04 10:30:00	QQQ	ETF	145.72	145.81	145.5	145.72	1199886.0
2017-10-04 11:00:00	QQQ	ETF	145.74	146.04	145.735	146.04	920211.0
2017-10-04 11:30:00	QQQ	ETF	146.04	146.11	145.94	146.03	784080.0
2017-10-04 12:00:00	QQQ	ETF	146.03	146.34	145.99	146.2	1461112.0
2017-10-04 12:30:00	QQQ	ETF	146.21	146.21	146.01	146.1	1180194.0

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

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