PREVIEW / etf_30min / 2016-04-04

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-04.parquet
  size:    394 KB
  rows:    13,238

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
2016-04-04 04:00:00	SPY	ETF	207.12	207.33	207.12	207.31	11864.0
2016-04-04 04:30:00	SPY	ETF	207.37	207.4	207.25	207.31	11025.0
2016-04-04 05:00:00	SPY	ETF	207.21	207.41	207.21	207.39	13128.0
2016-04-04 05:30:00	SPY	ETF	207.35	207.57	207.35	207.36	14938.0
2016-04-04 06:00:00	SPY	ETF	207.43	207.43	207.3	207.33	10860.0
2016-04-04 06:30:00	SPY	ETF	207.36	207.44	207.26	207.42	14006.0
2016-04-04 07:00:00	SPY	ETF	207.48	207.57	207.45	207.49	126926.0
2016-04-04 07:30:00	SPY	ETF	207.49	207.55	207.35	207.37	210814.0
2016-04-04 08:00:00	SPY	ETF	207.37	207.53	206.92	207.25	670522.0
2016-04-04 08:30:00	SPY	ETF	207.27	207.27	207.1	207.12	295958.0
2016-04-04 09:00:00	SPY	ETF	207.11	207.11	206.84	206.84	387813.0
2016-04-04 09:30:00	SPY	ETF	206.83	206.96	206.53	206.94	6932248.0
2016-04-04 10:00:00	SPY	ETF	206.94	207.07	206.7	206.86	4111419.0
2016-04-04 10:30:00	SPY	ETF	206.85	206.98	206.27	206.305	4820555.0
2016-04-04 11:00:00	SPY	ETF	206.31	206.43	206.165	206.39	4501490.0
2016-04-04 11:30:00	SPY	ETF	206.385	206.54	206.3	206.4689	2670035.0
2016-04-04 12:00:00	SPY	ETF	206.47	206.87	206.44	206.7	2829542.0
2016-04-04 12:30:00	SPY	ETF	206.71	206.84	206.65	206.76	1781065.0
2016-04-04 13:00:00	SPY	ETF	206.76	206.77	206.515	206.56	1586248.0
2016-04-04 13:30:00	SPY	ETF	206.56	206.59	206.22	206.28	2090290.0
2016-04-04 14:00:00	SPY	ETF	206.27	206.27	205.925	206.13	4306716.0
2016-04-04 14:30:00	SPY	ETF	206.14	206.35	206.11	206.235	2610039.0
2016-04-04 15:00:00	SPY	ETF	206.22	206.39	205.9	205.92	4308644.0
2016-04-04 15:30:00	SPY	ETF	205.915	206.27	205.89	206.27	9995865.0
2016-04-04 16:00:00	SPY	ETF	206.25	206.3	206.0864	206.17	2885902.0
2016-04-04 16:30:00	SPY	ETF	206.16	207.0072	206.03	206.12	239419.0
2016-04-04 17:00:00	SPY	ETF	206.07	206.09	206.0	206.05	71377.0
2016-04-04 17:30:00	SPY	ETF	206.03	206.05	205.94	205.96	179394.0
2016-04-04 18:00:00	SPY	ETF	205.97	205.97	205.71	205.83	453188.0
2016-04-04 18:30:00	SPY	ETF	205.84	205.91	205.82	205.89	85136.0
2016-04-04 19:00:00	SPY	ETF	205.85	205.99	205.84	205.88	50134.0
2016-04-04 19:30:00	SPY	ETF	205.88	205.88	205.78	205.8	77524.0
2016-04-04 04:00:00	QQQ	ETF	110.6	110.6	110.55	110.55	1100.0
2016-04-04 04:30:00	QQQ	ETF	110.69	110.69	110.69	110.69	100.0
2016-04-04 05:00:00	QQQ	ETF	110.69	110.77	110.69	110.77	1381.0
2016-04-04 05:30:00	QQQ	ETF	110.74	110.82	110.74	110.81	2720.0
2016-04-04 06:00:00	QQQ	ETF	110.75	110.75	110.69	110.69	1597.0
2016-04-04 06:30:00	QQQ	ETF	110.7	110.76	110.67	110.76	1800.0
2016-04-04 07:00:00	QQQ	ETF	110.76	110.78	110.74	110.76	5097.0
2016-04-04 07:30:00	QQQ	ETF	110.76	110.8	110.69	110.7	11490.0
2016-04-04 08:00:00	QQQ	ETF	110.36	110.7	110.36	110.61	261613.0
2016-04-04 08:30:00	QQQ	ETF	110.61	110.61	110.45	110.46	210124.0
2016-04-04 09:00:00	QQQ	ETF	110.45	110.48	110.28	110.28	99860.0
2016-04-04 09:30:00	QQQ	ETF	110.29	110.36	110.02	110.285	2645066.0
2016-04-04 10:00:00	QQQ	ETF	110.28	110.435	110.15	110.2238	1502174.0
2016-04-04 10:30:00	QQQ	ETF	110.225	110.3	109.8375	109.845	1216968.0
2016-04-04 11:00:00	QQQ	ETF	109.85	109.9099	109.68	109.79	859891.0
2016-04-04 11:30:00	QQQ	ETF	109.81	110.0	109.8	109.9585	390285.0
2016-04-04 12:00:00	QQQ	ETF	109.96	110.2467	109.9288	110.125	604419.0
2016-04-04 12:30:00	QQQ	ETF	110.12	110.35	110.1	110.29	423798.0

> showing 50 of 13,238 rows — these rows as CSV

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