PREVIEW / etf_30min / 2017-03-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-13.parquet
  size:    425 KB
  rows:    14,668

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-03-13 04:00:00	SPY	ETF	237.45	237.45	237.35	237.35	400.0
2017-03-13 04:30:00	SPY	ETF	237.49	237.51	237.49	237.51	900.0
2017-03-13 05:00:00	SPY	ETF	237.49	237.49	237.32	237.34	6572.0
2017-03-13 05:30:00	SPY	ETF	237.36	237.38	237.3	237.33	3821.0
2017-03-13 06:00:00	SPY	ETF	237.31	237.34	237.27	237.34	1985.0
2017-03-13 06:30:00	SPY	ETF	237.35	237.35	237.29	237.31	15502.0
2017-03-13 07:00:00	SPY	ETF	237.3	237.3	237.22	237.3	13006.0
2017-03-13 07:30:00	SPY	ETF	237.37	237.49	237.37	237.43	61321.0
2017-03-13 08:00:00	SPY	ETF	237.32	237.69	237.25	237.62	3711392.0
2017-03-13 08:30:00	SPY	ETF	237.61	237.76	237.52	237.65	273772.0
2017-03-13 09:00:00	SPY	ETF	237.57	237.67	237.53	237.6	214653.0
2017-03-13 09:30:00	SPY	ETF	237.62	237.86	237.44	237.45	4323636.0
2017-03-13 10:00:00	SPY	ETF	237.45	237.69	237.39	237.55	4409622.0
2017-03-13 10:30:00	SPY	ETF	237.55	237.63	237.39	237.51	3716773.0
2017-03-13 11:00:00	SPY	ETF	237.51	237.515	237.26	237.32	2734758.0
2017-03-13 11:30:00	SPY	ETF	237.32	237.63	237.24	237.62	3157752.0
2017-03-13 12:00:00	SPY	ETF	237.62	237.69	237.36	237.41	2135956.0
2017-03-13 12:30:00	SPY	ETF	237.41	237.57	237.37	237.52	1902537.0
2017-03-13 13:00:00	SPY	ETF	237.5246	237.58	237.41	237.46	1941390.0
2017-03-13 13:30:00	SPY	ETF	237.46	237.5	237.33	237.4774	1386447.0
2017-03-13 14:00:00	SPY	ETF	237.475	237.6	237.4	237.555	1534666.0
2017-03-13 14:30:00	SPY	ETF	237.55	237.66	237.515	237.66	1702608.0
2017-03-13 15:00:00	SPY	ETF	237.66	237.74	237.57	237.63	3719630.0
2017-03-13 15:30:00	SPY	ETF	237.635	237.85	237.6	237.76	10980269.0
2017-03-13 16:00:00	SPY	ETF	237.76	237.85	237.71	237.81	7851145.0
2017-03-13 16:30:00	SPY	ETF	237.81	237.83	237.72	237.77	485164.0
2017-03-13 17:00:00	SPY	ETF	237.77	237.77	237.74	237.75	64914.0
2017-03-13 17:30:00	SPY	ETF	237.74	237.75	237.72	237.75	22499.0
2017-03-13 18:00:00	SPY	ETF	237.75	237.79	237.71	237.76	165515.0
2017-03-13 18:30:00	SPY	ETF	237.76	237.76	237.73	237.73	3421.0
2017-03-13 19:00:00	SPY	ETF	237.72	237.75	237.71	237.71	8795.0
2017-03-13 19:30:00	SPY	ETF	237.74	237.8	237.69	237.8	1013344.0
2017-03-13 04:30:00	QQQ	ETF	131.32	131.32	131.32	131.32	300.0
2017-03-13 05:00:00	QQQ	ETF	131.26	131.26	131.26	131.26	200.0
2017-03-13 06:00:00	QQQ	ETF	131.22	131.22	131.22	131.22	199.0
2017-03-13 06:30:00	QQQ	ETF	131.21	131.25	131.19	131.23	17396.0
2017-03-13 07:00:00	QQQ	ETF	131.16	131.16	131.16	131.16	600.0
2017-03-13 07:30:00	QQQ	ETF	131.21	131.24	131.2	131.2	11694.0
2017-03-13 08:00:00	QQQ	ETF	131.2	131.31	131.2	131.26	40009.0
2017-03-13 08:30:00	QQQ	ETF	131.29	131.32	131.26	131.3	26196.0
2017-03-13 09:00:00	QQQ	ETF	131.3	131.33	131.26	131.33	25242.0
2017-03-13 09:30:00	QQQ	ETF	131.34	131.53	131.3204	131.37	1172248.0
2017-03-13 10:00:00	QQQ	ETF	131.37	131.45	131.27	131.371	987741.0
2017-03-13 10:30:00	QQQ	ETF	131.38	131.44	131.33	131.3753	659786.0
2017-03-13 11:00:00	QQQ	ETF	131.37	131.475	131.3254	131.4	521231.0
2017-03-13 11:30:00	QQQ	ETF	131.4	131.46	131.32	131.455	517623.0
2017-03-13 12:00:00	QQQ	ETF	131.45	131.52	131.32	131.3664	558138.0
2017-03-13 12:30:00	QQQ	ETF	131.37	131.47	131.37	131.455	364349.0
2017-03-13 13:00:00	QQQ	ETF	131.46	131.52	131.44	131.47	605408.0
2017-03-13 13:30:00	QQQ	ETF	131.4773	131.48	131.4	131.4657	384497.0

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

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