PREVIEW / etf_30min / 2016-01-25

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-25.parquet
  size:    393 KB
  rows:    13,264

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-01-25 04:00:00	SPY	ETF	189.7	189.92	189.37	189.92	13490.0
2016-01-25 04:30:00	SPY	ETF	189.77	190.18	189.73	189.87	2420.0
2016-01-25 05:00:00	SPY	ETF	189.99	190.5	189.82	190.44	8382.0
2016-01-25 05:30:00	SPY	ETF	190.38	190.38	190.12	190.22	3450.0
2016-01-25 06:00:00	SPY	ETF	190.13	190.29	190.0	190.13	10770.0
2016-01-25 06:30:00	SPY	ETF	190.04	190.12	189.84	190.08	35792.0
2016-01-25 07:00:00	SPY	ETF	190.09	190.37	190.01	190.15	104393.0
2016-01-25 07:30:00	SPY	ETF	190.17	190.32	190.11	190.31	62009.0
2016-01-25 08:00:00	SPY	ETF	190.28	190.52	189.52	189.61	465763.0
2016-01-25 08:30:00	SPY	ETF	189.65	189.93	189.25	189.35	1019997.0
2016-01-25 09:00:00	SPY	ETF	189.36	189.93	189.36	189.92	693317.0
2016-01-25 09:30:00	SPY	ETF	189.92	190.12	189.27	189.62	13726875.0
2016-01-25 10:00:00	SPY	ETF	189.615	190.15	189.26	189.64	10657891.0
2016-01-25 10:30:00	SPY	ETF	189.649	189.85	189.04	189.26	8105650.0
2016-01-25 11:00:00	SPY	ETF	189.25	189.4	188.75	189.34	9107338.0
2016-01-25 11:30:00	SPY	ETF	189.345	189.5	188.95	189.29	5300052.0
2016-01-25 12:00:00	SPY	ETF	189.29	189.49	189.045	189.33	3976983.0
2016-01-25 12:30:00	SPY	ETF	189.32	189.66	189.18	189.6111	4066105.0
2016-01-25 13:00:00	SPY	ETF	189.62	190.11	189.62	189.835	5988568.0
2016-01-25 13:30:00	SPY	ETF	189.835	189.965	189.14	189.15	5023108.0
2016-01-25 14:00:00	SPY	ETF	189.15	189.41	188.9024	189.25	5905761.0
2016-01-25 14:30:00	SPY	ETF	189.25	189.28	188.79	188.98	5845999.0
2016-01-25 15:00:00	SPY	ETF	188.98	189.21	187.95	188.04	11327250.0
2016-01-25 15:30:00	SPY	ETF	188.035	188.17	187.41	187.66	21453966.0
2016-01-25 16:00:00	SPY	ETF	187.66	188.61	187.4967	187.56	9204368.0
2016-01-25 16:30:00	SPY	ETF	187.56	187.78	187.33	187.75	2526028.0
2016-01-25 17:00:00	SPY	ETF	187.71	187.71	187.56	187.56	132971.0
2016-01-25 17:30:00	SPY	ETF	187.59	187.69	187.52	187.64	282612.0
2016-01-25 18:00:00	SPY	ETF	187.68	187.78	187.59	187.7	267830.0
2016-01-25 18:30:00	SPY	ETF	187.71	187.74	187.11	187.29	159207.0
2016-01-25 19:00:00	SPY	ETF	187.33	187.37	187.1	187.34	213336.0
2016-01-25 19:30:00	SPY	ETF	187.36	187.49	187.16	187.27	176203.0
2016-01-25 04:00:00	QQQ	ETF	103.25	103.34	103.08	103.34	8959.0
2016-01-25 04:30:00	QQQ	ETF	103.3	103.5	103.3	103.4	1282.0
2016-01-25 05:00:00	QQQ	ETF	103.38	103.38	103.38	103.38	197.0
2016-01-25 05:30:00	QQQ	ETF	103.54	103.54	103.45	103.48	700.0
2016-01-25 06:00:00	QQQ	ETF	103.48	103.51	103.4	103.4	1300.0
2016-01-25 06:30:00	QQQ	ETF	103.39	103.39	103.39	103.39	100.0
2016-01-25 07:00:00	QQQ	ETF	103.45	103.58	103.45	103.54	8700.0
2016-01-25 07:30:00	QQQ	ETF	103.45	103.57	103.45	103.57	3600.0
2016-01-25 08:00:00	QQQ	ETF	103.57	103.59	103.25	103.25	64265.0
2016-01-25 08:30:00	QQQ	ETF	103.37	103.39	103.1	103.13	61105.0
2016-01-25 09:00:00	QQQ	ETF	103.14	103.48	103.14	103.46	183462.0
2016-01-25 09:30:00	QQQ	ETF	103.46	103.69	103.235	103.48	4592164.0
2016-01-25 10:00:00	QQQ	ETF	103.47	103.8	103.36	103.62	3747968.0
2016-01-25 10:30:00	QQQ	ETF	103.62	103.76	103.31	103.47	2300260.0
2016-01-25 11:00:00	QQQ	ETF	103.46	103.47	103.13	103.45	2448045.0
2016-01-25 11:30:00	QQQ	ETF	103.45	103.53	103.21	103.36	2173067.0
2016-01-25 12:00:00	QQQ	ETF	103.36	103.46	103.25	103.36	1045997.0
2016-01-25 12:30:00	QQQ	ETF	103.3528	103.74	103.29	103.7	1022644.0

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

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