PREVIEW / etf_30min / 2017-04-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-05.parquet
  size:    440 KB
  rows:    14,955

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-04-05 04:00:00	SPY	ETF	235.24	235.32	235.2	235.32	2175.0
2017-04-05 04:30:00	SPY	ETF	235.28	235.3	235.2	235.23	7359.0
2017-04-05 05:00:00	SPY	ETF	235.34	235.54	235.34	235.52	19701.0
2017-04-05 05:30:00	SPY	ETF	235.51	235.53	235.47	235.47	2404.0
2017-04-05 06:00:00	SPY	ETF	235.42	235.47	235.41	235.42	119304.0
2017-04-05 06:30:00	SPY	ETF	235.44	235.54	235.4	235.45	37512.0
2017-04-05 07:00:00	SPY	ETF	235.45	235.46	235.26	235.27	98038.0
2017-04-05 07:30:00	SPY	ETF	235.3	235.68	235.3	235.64	128891.0
2017-04-05 08:00:00	SPY	ETF	235.44	236.07	235.3	235.98	531837.0
2017-04-05 08:30:00	SPY	ETF	235.97	236.18	235.91	236.11	281373.0
2017-04-05 09:00:00	SPY	ETF	236.11	236.27	236.04	236.24	359578.0
2017-04-05 09:30:00	SPY	ETF	236.26	236.93	236.17	236.875	7962510.0
2017-04-05 10:00:00	SPY	ETF	236.875	237.39	236.72	237.225	7759693.0
2017-04-05 10:30:00	SPY	ETF	237.23	237.23	236.94	237.1	5034090.0
2017-04-05 11:00:00	SPY	ETF	237.105	237.19	236.53	236.55	5248527.0
2017-04-05 11:30:00	SPY	ETF	236.5599	237.0	236.41	236.75	4793008.0
2017-04-05 12:00:00	SPY	ETF	236.76	237.09	236.71	237.01	2097391.0
2017-04-05 12:30:00	SPY	ETF	237.02	237.2	236.99	237.0835	3011899.0
2017-04-05 13:00:00	SPY	ETF	237.08	237.33	237.08	237.21	2966945.0
2017-04-05 13:30:00	SPY	ETF	237.215	237.35	237.1306	237.24	1956588.0
2017-04-05 14:00:00	SPY	ETF	237.24	237.25	236.79	236.97	6431784.0
2017-04-05 14:30:00	SPY	ETF	236.97	237.01	236.02	236.1	7575912.0
2017-04-05 15:00:00	SPY	ETF	236.1	236.33	234.94	235.3	12533011.0
2017-04-05 15:30:00	SPY	ETF	235.29	235.31	234.54	234.77	23126033.0
2017-04-05 16:00:00	SPY	ETF	234.77	236.2	234.36	234.58	8928424.0
2017-04-05 16:30:00	SPY	ETF	234.56	234.78	234.29	234.43	585651.0
2017-04-05 17:00:00	SPY	ETF	234.78	234.78	234.35	234.4	207393.0
2017-04-05 17:30:00	SPY	ETF	234.4	234.82	234.35	234.43	107479.0
2017-04-05 18:00:00	SPY	ETF	234.44	234.47	234.3	234.4	142283.0
2017-04-05 18:30:00	SPY	ETF	234.4	234.6	234.4	234.57	234595.0
2017-04-05 19:00:00	SPY	ETF	234.56	234.64	234.52	234.6	67528.0
2017-04-05 19:30:00	SPY	ETF	234.6	234.61	234.3	234.31	44841.0
2017-04-05 04:00:00	QQQ	ETF	132.37	132.42	132.37	132.42	3100.0
2017-04-05 05:30:00	QQQ	ETF	132.53	132.54	132.46	132.46	10200.0
2017-04-05 06:00:00	QQQ	ETF	132.45	132.5	132.44	132.45	2500.0
2017-04-05 06:30:00	QQQ	ETF	132.46	132.51	132.46	132.5	5648.0
2017-04-05 07:00:00	QQQ	ETF	132.48	132.48	132.38	132.39	18048.0
2017-04-05 07:30:00	QQQ	ETF	132.57	132.57	132.53	132.53	9300.0
2017-04-05 08:00:00	QQQ	ETF	132.45	132.65	132.39	132.6	46272.0
2017-04-05 08:30:00	QQQ	ETF	132.61	132.63	132.48	132.59	117837.0
2017-04-05 09:00:00	QQQ	ETF	132.59	132.7	132.56	132.67	77824.0
2017-04-05 09:30:00	QQQ	ETF	132.68	133.03	132.58	132.97	2672464.0
2017-04-05 10:00:00	QQQ	ETF	132.965	133.11	132.85	133.09	2026557.0
2017-04-05 10:30:00	QQQ	ETF	133.09	133.32	133.02	133.28	1625414.0
2017-04-05 11:00:00	QQQ	ETF	133.28	133.39	133.06	133.07	1521528.0
2017-04-05 11:30:00	QQQ	ETF	133.078	133.31	133.0	133.185	885599.0
2017-04-05 12:00:00	QQQ	ETF	133.19	133.41	133.17	133.33	519950.0
2017-04-05 12:30:00	QQQ	ETF	133.34	133.44	133.32	133.37	692233.0
2017-04-05 13:00:00	QQQ	ETF	133.38	133.47	133.36	133.39	843485.0
2017-04-05 13:30:00	QQQ	ETF	133.39	133.48	133.375	133.42	736066.0

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

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