PREVIEW / etf_30min / 2017-05-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-19.parquet
  size:    430 KB
  rows:    14,672

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-05-19 04:00:00	SPY	ETF	236.71	236.81	236.7	236.81	1923.0
2017-05-19 04:30:00	SPY	ETF	236.93	237.2	236.93	237.01	22800.0
2017-05-19 05:00:00	SPY	ETF	237.0	237.35	237.0	237.27	14415.0
2017-05-19 05:30:00	SPY	ETF	237.3	237.41	237.3	237.31	7910.0
2017-05-19 06:00:00	SPY	ETF	237.21	237.21	237.09	237.11	21916.0
2017-05-19 06:30:00	SPY	ETF	237.12	237.13	237.1	237.11	4600.0
2017-05-19 07:00:00	SPY	ETF	237.11	237.27	237.1	237.23	73803.0
2017-05-19 07:30:00	SPY	ETF	237.22	237.28	237.14	237.19	64130.0
2017-05-19 08:00:00	SPY	ETF	237.18	237.36	237.1	237.3	349283.0
2017-05-19 08:30:00	SPY	ETF	237.29	237.34	236.77	237.27	267034.0
2017-05-19 09:00:00	SPY	ETF	237.29	237.42	237.09	237.33	1087151.0
2017-05-19 09:30:00	SPY	ETF	237.33	238.18	237.27	237.99	10789207.0
2017-05-19 10:00:00	SPY	ETF	238.0	238.49	237.96	238.37	13413470.0
2017-05-19 10:30:00	SPY	ETF	238.38	238.48	238.17	238.42	7176814.0
2017-05-19 11:00:00	SPY	ETF	238.42	238.6	238.32	238.45	7146749.0
2017-05-19 11:30:00	SPY	ETF	238.455	238.59	238.28	238.59	4398825.0
2017-05-19 12:00:00	SPY	ETF	238.59	238.73	238.58	238.7	5276038.0
2017-05-19 12:30:00	SPY	ETF	238.7	238.95	238.68	238.84	4835765.0
2017-05-19 13:00:00	SPY	ETF	238.8483	238.85	238.64	238.74	7722143.0
2017-05-19 13:30:00	SPY	ETF	238.745	238.79	238.64	238.76	2904136.0
2017-05-19 14:00:00	SPY	ETF	238.765	238.9	238.68	238.83	2939344.0
2017-05-19 14:30:00	SPY	ETF	238.82	239.08	238.8	238.86	4275684.0
2017-05-19 15:00:00	SPY	ETF	238.8508	238.9	238.15	238.24	10603850.0
2017-05-19 15:30:00	SPY	ETF	238.245	238.355	238.09	238.3	14763149.0
2017-05-19 16:00:00	SPY	ETF	238.3	238.51	238.22	238.5	12041273.0
2017-05-19 16:30:00	SPY	ETF	238.5	238.54	238.31	238.54	2791927.0
2017-05-19 17:00:00	SPY	ETF	238.5	238.52	238.48	238.48	371949.0
2017-05-19 17:30:00	SPY	ETF	238.48	238.48	238.37	238.47	96878.0
2017-05-19 18:00:00	SPY	ETF	238.48	238.55	238.31	238.5	144430.0
2017-05-19 18:30:00	SPY	ETF	238.51	238.51	238.32	238.33	107957.0
2017-05-19 19:00:00	SPY	ETF	238.37	238.49	238.35	238.36	75395.0
2017-05-19 19:30:00	SPY	ETF	238.34	238.35	237.99	237.99	244760.0
2017-05-19 04:00:00	QQQ	ETF	137.27	137.27	137.27	137.27	155.0
2017-05-19 04:30:00	QQQ	ETF	137.64	137.64	137.64	137.64	300.0
2017-05-19 05:00:00	QQQ	ETF	137.7	137.7	137.7	137.7	464.0
2017-05-19 05:30:00	QQQ	ETF	137.66	137.75	137.62	137.75	32153.0
2017-05-19 06:00:00	QQQ	ETF	137.63	137.63	137.6	137.6	750.0
2017-05-19 06:30:00	QQQ	ETF	137.58	137.58	137.56	137.56	5300.0
2017-05-19 07:00:00	QQQ	ETF	137.56	137.68	137.56	137.66	23601.0
2017-05-19 07:30:00	QQQ	ETF	137.66	137.68	137.63	137.65	9770.0
2017-05-19 08:00:00	QQQ	ETF	137.64	137.87	137.61	137.87	470068.0
2017-05-19 08:30:00	QQQ	ETF	137.81	137.85	137.76	137.78	140169.0
2017-05-19 09:00:00	QQQ	ETF	137.78	137.87	137.71	137.71	167848.0
2017-05-19 09:30:00	QQQ	ETF	137.71	138.2099	137.66	138.03	4077793.0
2017-05-19 10:00:00	QQQ	ETF	138.03	138.29	137.9754	138.19	1848802.0
2017-05-19 10:30:00	QQQ	ETF	138.19	138.25	138.0711	138.21	1107886.0
2017-05-19 11:00:00	QQQ	ETF	138.215	138.32	138.1	138.14	1295215.0
2017-05-19 11:30:00	QQQ	ETF	138.139	138.2	138.015	138.2	791682.0
2017-05-19 12:00:00	QQQ	ETF	138.21	138.29	138.191	138.26	849276.0
2017-05-19 12:30:00	QQQ	ETF	138.255	138.42	138.25	138.34	1744757.0

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

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