PREVIEW / etf_30min / 2017-11-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-17.parquet
  size:    443 KB
  rows:    15,300

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-11-17 04:00:00	SPY	ETF	258.22	258.25	258.14	258.2	3904.0
2017-11-17 04:30:00	SPY	ETF	258.2	258.22	258.18	258.2	2800.0
2017-11-17 05:00:00	SPY	ETF	258.2	258.21	258.15	258.15	1000.0
2017-11-17 05:30:00	SPY	ETF	258.15	258.31	258.04	258.3	9500.0
2017-11-17 06:00:00	SPY	ETF	258.28	258.31	258.25	258.3	7200.0
2017-11-17 06:30:00	SPY	ETF	258.32	258.45	258.32	258.45	16070.0
2017-11-17 07:00:00	SPY	ETF	258.45	258.55	258.43	258.52	70929.0
2017-11-17 07:30:00	SPY	ETF	258.5	258.66	258.49	258.64	91089.0
2017-11-17 08:00:00	SPY	ETF	258.51	258.62	258.48	258.54	257069.0
2017-11-17 08:30:00	SPY	ETF	258.55	258.55	258.33	258.43	342446.0
2017-11-17 09:00:00	SPY	ETF	258.45	258.46	258.18	258.21	660566.0
2017-11-17 09:30:00	SPY	ETF	258.22	258.34	257.97	258.27	7718441.0
2017-11-17 10:00:00	SPY	ETF	258.275	258.44	258.03	258.22	3610931.0
2017-11-17 10:30:00	SPY	ETF	258.22	258.34	258.035	258.25	5139385.0
2017-11-17 11:00:00	SPY	ETF	258.25	258.29	257.89	258.15	3386205.0
2017-11-17 11:30:00	SPY	ETF	258.15	258.29	258.02	258.23	2266914.0
2017-11-17 12:00:00	SPY	ETF	258.22	258.35	258.09	258.345	1541668.0
2017-11-17 12:30:00	SPY	ETF	258.35	258.36	258.18	258.295	2697340.0
2017-11-17 13:00:00	SPY	ETF	258.29	258.33	258.09	258.2	1997582.0
2017-11-17 13:30:00	SPY	ETF	258.2	258.3	258.15	258.215	1817667.0
2017-11-17 14:00:00	SPY	ETF	258.21	258.28	258.1	258.17	1998274.0
2017-11-17 14:30:00	SPY	ETF	258.17	258.5882	258.04	258.205	3276800.0
2017-11-17 15:00:00	SPY	ETF	258.2	258.21	257.97	258.01	6994918.0
2017-11-17 15:30:00	SPY	ETF	258.0	258.09	257.77	257.89	17691158.0
2017-11-17 16:00:00	SPY	ETF	257.86	258.01	257.7	257.73	8792468.0
2017-11-17 16:30:00	SPY	ETF	257.73	257.9113	257.62	257.71	2550545.0
2017-11-17 17:00:00	SPY	ETF	257.75	257.86	257.61	257.62	507574.0
2017-11-17 17:30:00	SPY	ETF	257.65	257.65	257.61	257.61	10406.0
2017-11-17 18:00:00	SPY	ETF	257.61	257.66	257.56	257.57	35583.0
2017-11-17 18:30:00	SPY	ETF	257.6	257.67	257.6	257.66	9396.0
2017-11-17 19:00:00	SPY	ETF	257.66	257.68	257.66	257.68	4500.0
2017-11-17 19:30:00	SPY	ETF	257.9208	257.9208	257.6	257.64	1219515.0
2017-11-17 05:00:00	QQQ	ETF	154.46	154.51	154.45	154.45	5700.0
2017-11-17 05:30:00	QQQ	ETF	154.46	154.51	154.46	154.51	4980.0
2017-11-17 06:00:00	QQQ	ETF	154.54	154.6	154.54	154.59	30100.0
2017-11-17 06:30:00	QQQ	ETF	154.59	154.59	154.59	154.59	4500.0
2017-11-17 07:00:00	QQQ	ETF	154.58	154.67	154.58	154.62	25850.0
2017-11-17 07:30:00	QQQ	ETF	154.61	154.7	154.61	154.68	19592.0
2017-11-17 08:00:00	QQQ	ETF	154.61	154.68	154.52	154.52	48405.0
2017-11-17 08:30:00	QQQ	ETF	154.644	154.644	154.45	154.56	146360.0
2017-11-17 09:00:00	QQQ	ETF	154.56	154.63	154.48	154.57	180485.0
2017-11-17 09:30:00	QQQ	ETF	154.58	154.69	154.32	154.42	2859902.0
2017-11-17 10:00:00	QQQ	ETF	154.43	154.48	154.24	154.33	2114790.0
2017-11-17 10:30:00	QQQ	ETF	154.32	154.48	154.24	154.455	987667.0
2017-11-17 11:00:00	QQQ	ETF	154.455	154.505	154.09	154.36	1608842.0
2017-11-17 11:30:00	QQQ	ETF	154.37	154.39	154.21	154.34	665644.0
2017-11-17 12:00:00	QQQ	ETF	154.34	154.43	154.215	154.3852	876592.0
2017-11-17 12:30:00	QQQ	ETF	154.39	154.4	154.25	154.29	634015.0
2017-11-17 13:00:00	QQQ	ETF	154.29	154.32	154.1901	154.2768	798752.0
2017-11-17 13:30:00	QQQ	ETF	154.27	154.31	154.23	154.24	739709.0

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

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