PREVIEW / etf_30min / 2017-06-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-22.parquet
  size:    427 KB
  rows:    14,656

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-06-22 04:00:00	SPY	ETF	242.6	242.64	242.44	242.57	2564.0
2017-06-22 04:30:00	SPY	ETF	242.62	242.62	242.49	242.49	1215.0
2017-06-22 05:00:00	SPY	ETF	242.56	242.58	242.45	242.45	4510.0
2017-06-22 05:30:00	SPY	ETF	242.48	242.67	242.48	242.64	5000.0
2017-06-22 06:00:00	SPY	ETF	242.68	242.87	242.68	242.85	59500.0
2017-06-22 06:30:00	SPY	ETF	242.88	242.9	242.81	242.86	57700.0
2017-06-22 07:00:00	SPY	ETF	242.85	242.93	242.79	242.93	110479.0
2017-06-22 07:30:00	SPY	ETF	242.9	242.9	242.85	242.88	38067.0
2017-06-22 08:00:00	SPY	ETF	242.93	242.93	242.75	242.79	119012.0
2017-06-22 08:30:00	SPY	ETF	242.78	242.91	242.75	242.78	84662.0
2017-06-22 09:00:00	SPY	ETF	242.77	243.01	242.74	242.99	319191.0
2017-06-22 09:30:00	SPY	ETF	242.96	243.04	242.64	242.9	5310310.0
2017-06-22 10:00:00	SPY	ETF	242.91	242.99	242.7	242.8215	2417238.0
2017-06-22 10:30:00	SPY	ETF	242.83	243.25	242.65	243.1655	3355746.0
2017-06-22 11:00:00	SPY	ETF	243.17	243.47	243.15	243.43	2587062.0
2017-06-22 11:30:00	SPY	ETF	243.43	243.45	243.2	243.37	2106914.0
2017-06-22 12:00:00	SPY	ETF	243.37	243.41	243.155	243.27	1694999.0
2017-06-22 12:30:00	SPY	ETF	243.27	243.51	243.24	243.405	1596784.0
2017-06-22 13:00:00	SPY	ETF	243.41	243.53	243.3	243.43	1576746.0
2017-06-22 13:30:00	SPY	ETF	243.42	243.45	243.34	243.395	1069470.0
2017-06-22 14:00:00	SPY	ETF	243.4	243.47	243.26	243.32	2041428.0
2017-06-22 14:30:00	SPY	ETF	243.32	243.39	243.24	243.37	1430138.0
2017-06-22 15:00:00	SPY	ETF	243.37	243.47	243.26	243.295	3027647.0
2017-06-22 15:30:00	SPY	ETF	243.29	243.3	242.8	242.83	7538440.0
2017-06-22 16:00:00	SPY	ETF	242.82	243.0056	242.68	242.75	5605061.0
2017-06-22 16:30:00	SPY	ETF	242.75	242.84	242.75	242.76	1056669.0
2017-06-22 17:00:00	SPY	ETF	242.75	242.75	242.7	242.73	30291.0
2017-06-22 17:30:00	SPY	ETF	242.73	242.77	242.73	242.74	5535.0
2017-06-22 18:00:00	SPY	ETF	242.77	242.84	242.76	242.83	36364.0
2017-06-22 18:30:00	SPY	ETF	242.84	242.88	242.84	242.88	9522.0
2017-06-22 19:00:00	SPY	ETF	242.87	242.93	242.87	242.88	15445.0
2017-06-22 19:30:00	SPY	ETF	242.89	242.93	242.89	242.91	13507.0
2017-06-22 04:00:00	QQQ	ETF	140.75	140.88	140.6	140.81	12738.0
2017-06-22 04:30:00	QQQ	ETF	140.86	140.87	140.75	140.75	4400.0
2017-06-22 05:00:00	QQQ	ETF	140.64	140.64	140.59	140.59	1200.0
2017-06-22 05:30:00	QQQ	ETF	140.59	140.8	140.59	140.79	12800.0
2017-06-22 06:00:00	QQQ	ETF	140.76	140.89	140.75	140.89	7002.0
2017-06-22 06:30:00	QQQ	ETF	140.92	140.93	140.92	140.93	10200.0
2017-06-22 07:00:00	QQQ	ETF	140.88	140.98	140.84	140.98	51880.0
2017-06-22 07:30:00	QQQ	ETF	140.97	140.97	140.92	140.92	95150.0
2017-06-22 08:00:00	QQQ	ETF	140.89	140.91	140.78	140.88	86489.0
2017-06-22 08:30:00	QQQ	ETF	140.82	141.05	140.82	140.91	70421.0
2017-06-22 09:00:00	QQQ	ETF	140.91	141.0	140.83	140.95	80348.0
2017-06-22 09:30:00	QQQ	ETF	140.94	140.98	140.42	140.53	4155927.0
2017-06-22 10:00:00	QQQ	ETF	140.54	140.69	140.34	140.61	1432008.0
2017-06-22 10:30:00	QQQ	ETF	140.6	140.909	140.49	140.79	1874166.0
2017-06-22 11:00:00	QQQ	ETF	140.79	140.89	140.66	140.83	1040914.0
2017-06-22 11:30:00	QQQ	ETF	140.84	140.84	140.66	140.81	1538599.0
2017-06-22 12:00:00	QQQ	ETF	140.81	140.86	140.6955	140.82	535763.0
2017-06-22 12:30:00	QQQ	ETF	140.82	141.18	140.8	141.12	1607801.0

> showing 50 of 14,656 rows — these rows as CSV

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