PREVIEW / etf_30min / 2017-05-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-08.parquet
  size:    429 KB
  rows:    14,796

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-08 04:00:00	SPY	ETF	239.5	239.72	239.5	239.72	16496.0
2017-05-08 04:30:00	SPY	ETF	239.72	239.72	239.51	239.56	8985.0
2017-05-08 05:00:00	SPY	ETF	239.57	239.63	239.43	239.6	34560.0
2017-05-08 05:30:00	SPY	ETF	239.53	239.6	239.45	239.6	3540.0
2017-05-08 06:00:00	SPY	ETF	239.58	239.79	239.55	239.79	12200.0
2017-05-08 06:30:00	SPY	ETF	239.79	239.85	239.75	239.77	1500.0
2017-05-08 07:00:00	SPY	ETF	239.78	239.82	239.71	239.82	33678.0
2017-05-08 07:30:00	SPY	ETF	239.84	239.87	239.69	239.69	57151.0
2017-05-08 08:00:00	SPY	ETF	239.73	239.84	239.57	239.62	625701.0
2017-05-08 08:30:00	SPY	ETF	239.66	239.66	239.51	239.58	140075.0
2017-05-08 09:00:00	SPY	ETF	239.59	239.77	239.52	239.76	243694.0
2017-05-08 09:30:00	SPY	ETF	239.75	239.92	239.41	239.47	6352343.0
2017-05-08 10:00:00	SPY	ETF	239.46	239.6	239.39	239.43	2960844.0
2017-05-08 10:30:00	SPY	ETF	239.44	239.63	239.3	239.4	4575164.0
2017-05-08 11:00:00	SPY	ETF	239.4	239.47	239.17	239.23	3452959.0
2017-05-08 11:30:00	SPY	ETF	239.23	239.5	239.22	239.44	2547357.0
2017-05-08 12:00:00	SPY	ETF	239.44	239.5	239.33	239.4	1154358.0
2017-05-08 12:30:00	SPY	ETF	239.39	239.66	239.39	239.59	1792692.0
2017-05-08 13:00:00	SPY	ETF	239.585	239.67	239.54	239.6101	2079892.0
2017-05-08 13:30:00	SPY	ETF	239.61	239.71	239.59	239.7093	1238953.0
2017-05-08 14:00:00	SPY	ETF	239.705	239.71	239.5399	239.6262	4022019.0
2017-05-08 14:30:00	SPY	ETF	239.625	239.635	239.4999	239.61	2092813.0
2017-05-08 15:00:00	SPY	ETF	239.62	239.6599	239.53	239.58	2893598.0
2017-05-08 15:30:00	SPY	ETF	239.57	239.7	239.39	239.67	7235214.0
2017-05-08 16:00:00	SPY	ETF	239.67	239.74	239.4805	239.71	3734190.0
2017-05-08 16:30:00	SPY	ETF	239.71	239.71	239.65	239.67	356891.0
2017-05-08 17:00:00	SPY	ETF	239.7	239.71	239.69	239.71	25444.0
2017-05-08 17:30:00	SPY	ETF	239.68	239.71	239.66	239.66	37839.0
2017-05-08 18:00:00	SPY	ETF	239.66	239.76	239.65	239.74	52028.0
2017-05-08 18:30:00	SPY	ETF	239.73	239.75	239.71	239.75	9363.0
2017-05-08 19:00:00	SPY	ETF	239.76	239.76	239.72	239.72	2065.0
2017-05-08 19:30:00	SPY	ETF	239.72	239.72	239.66	239.68	24010.0
2017-05-08 04:00:00	QQQ	ETF	137.41	137.46	137.39	137.46	2550.0
2017-05-08 05:00:00	QQQ	ETF	137.47	137.47	137.47	137.47	200.0
2017-05-08 05:30:00	QQQ	ETF	137.47	137.47	137.39	137.39	5700.0
2017-05-08 06:00:00	QQQ	ETF	137.6	137.6	137.6	137.6	100.0
2017-05-08 06:30:00	QQQ	ETF	137.6	137.62	137.57	137.58	2700.0
2017-05-08 07:00:00	QQQ	ETF	137.59	137.6	137.56	137.6	30857.0
2017-05-08 07:30:00	QQQ	ETF	137.6	137.64	137.6	137.61	1083.0
2017-05-08 08:00:00	QQQ	ETF	137.59	137.61	137.53	137.55	32763.0
2017-05-08 08:30:00	QQQ	ETF	137.54	137.54	137.48	137.5	2087.0
2017-05-08 09:00:00	QQQ	ETF	137.52	137.62	137.52	137.6	32411.0
2017-05-08 09:30:00	QQQ	ETF	137.61	137.735	137.435	137.44	1707291.0
2017-05-08 10:00:00	QQQ	ETF	137.44	137.56	137.4	137.49	696503.0
2017-05-08 10:30:00	QQQ	ETF	137.49	137.67	137.43	137.48	1101125.0
2017-05-08 11:00:00	QQQ	ETF	137.48	137.52	137.33	137.37	427762.0
2017-05-08 11:30:00	QQQ	ETF	137.38	137.58	137.37	137.53	672319.0
2017-05-08 12:00:00	QQQ	ETF	137.54	137.61	137.51	137.6001	464455.0
2017-05-08 12:30:00	QQQ	ETF	137.605	137.75	137.6	137.67	877964.0
2017-05-08 13:00:00	QQQ	ETF	137.6672	137.68	137.6	137.65	381136.0

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

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