PREVIEW / etf_30min / 2017-03-09

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-09.parquet
  size:    437 KB
  rows:    14,945

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-09 04:00:00	SPY	ETF	236.79	236.95	236.77	236.81	18052.0
2017-03-09 04:30:00	SPY	ETF	236.81	236.81	236.76	236.78	11900.0
2017-03-09 05:00:00	SPY	ETF	236.78	236.78	236.57	236.65	13491.0
2017-03-09 05:30:00	SPY	ETF	236.63	236.66	236.46	236.46	30870.0
2017-03-09 06:00:00	SPY	ETF	236.46	236.46	236.27	236.46	33630.0
2017-03-09 06:30:00	SPY	ETF	236.41	236.53	236.4	236.53	4700.0
2017-03-09 07:00:00	SPY	ETF	236.56	236.56	236.41	236.41	81975.0
2017-03-09 07:30:00	SPY	ETF	236.41	236.45	236.2	236.2	158192.0
2017-03-09 08:00:00	SPY	ETF	236.29	236.53	236.27	236.41	3646574.0
2017-03-09 08:30:00	SPY	ETF	236.44	236.84	236.4	236.79	409365.0
2017-03-09 09:00:00	SPY	ETF	236.8	236.83	236.59	236.68	728307.0
2017-03-09 09:30:00	SPY	ETF	236.7	237.05	236.48	236.89	7774715.0
2017-03-09 10:00:00	SPY	ETF	236.88	237.24	236.87	236.97	5067371.0
2017-03-09 10:30:00	SPY	ETF	236.971	237.03	236.7	236.91	5022978.0
2017-03-09 11:00:00	SPY	ETF	236.905	237.04	236.74	236.96	2776479.0
2017-03-09 11:30:00	SPY	ETF	236.95	237.09	236.83	236.895	4907501.0
2017-03-09 12:00:00	SPY	ETF	236.9	237.01	236.75	236.76	1652196.0
2017-03-09 12:30:00	SPY	ETF	236.77	236.88	236.72	236.88	1786952.0
2017-03-09 13:00:00	SPY	ETF	236.875	236.97	236.72	236.72	2609174.0
2017-03-09 13:30:00	SPY	ETF	236.72	236.726	236.42	236.46	4567888.0
2017-03-09 14:00:00	SPY	ETF	236.465	236.51	235.74	236.1001	8913015.0
2017-03-09 14:30:00	SPY	ETF	236.1	236.33	235.91	236.32	4766485.0
2017-03-09 15:00:00	SPY	ETF	236.32	236.73	236.3	236.71	7624867.0
2017-03-09 15:30:00	SPY	ETF	236.71	236.97	236.69	236.82	12069829.0
2017-03-09 16:00:00	SPY	ETF	236.83	236.99	236.75	236.93	6332505.0
2017-03-09 16:30:00	SPY	ETF	236.93	237.12	236.79	237.11	672395.0
2017-03-09 17:00:00	SPY	ETF	237.08	237.09	236.95	237.0	153305.0
2017-03-09 17:30:00	SPY	ETF	237.02	237.05	236.79	237.05	68559.0
2017-03-09 18:00:00	SPY	ETF	237.05	237.1	236.96	237.1	66572.0
2017-03-09 18:30:00	SPY	ETF	237.08	237.41	237.08	237.3	83343.0
2017-03-09 19:00:00	SPY	ETF	237.27	237.39	237.24	237.37	146069.0
2017-03-09 19:30:00	SPY	ETF	237.39	237.4	237.29	237.35	25375.0
2017-03-09 06:00:00	QQQ	ETF	130.66	130.66	130.62	130.62	500.0
2017-03-09 06:30:00	QQQ	ETF	130.7	130.7	130.7	130.7	250.0
2017-03-09 07:00:00	QQQ	ETF	130.72	130.75	130.72	130.72	17700.0
2017-03-09 07:30:00	QQQ	ETF	130.69	130.7	130.6	130.63	17491.0
2017-03-09 08:00:00	QQQ	ETF	130.65	130.75	130.63	130.7	22266.0
2017-03-09 08:30:00	QQQ	ETF	130.7	130.82	130.7	130.82	41858.0
2017-03-09 09:00:00	QQQ	ETF	130.74	130.78	130.65	130.67	117315.0
2017-03-09 09:30:00	QQQ	ETF	130.71	130.905	130.44	130.834	1674770.0
2017-03-09 10:00:00	QQQ	ETF	130.83	131.02	130.75	130.81	903484.0
2017-03-09 10:30:00	QQQ	ETF	130.81	130.8873	130.69	130.872	495675.0
2017-03-09 11:00:00	QQQ	ETF	130.88	130.92	130.73	130.87	499175.0
2017-03-09 11:30:00	QQQ	ETF	130.875	130.97	130.84	130.87	639413.0
2017-03-09 12:00:00	QQQ	ETF	130.8648	130.9278	130.78	130.8035	352741.0
2017-03-09 12:30:00	QQQ	ETF	130.8	130.89	130.76	130.86	497362.0
2017-03-09 13:00:00	QQQ	ETF	130.87	130.9	130.8	130.8	277797.0
2017-03-09 13:30:00	QQQ	ETF	130.78	130.78	130.58	130.6099	3137433.0
2017-03-09 14:00:00	QQQ	ETF	130.6	130.62	130.14	130.345	2378739.0
2017-03-09 14:30:00	QQQ	ETF	130.34	130.525	130.27	130.52	1869110.0

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

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