PREVIEW / etf_30min / 2010-03-25

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-25.parquet
  size:    260 KB
  rows:    8,653

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
2010-03-25 04:00:00	SPY	ETF	117.09	117.09	117.09	117.09	100.0
2010-03-25 05:00:00	SPY	ETF	117.11	117.19	117.11	117.19	1155.0
2010-03-25 05:30:00	SPY	ETF	117.21	117.31	117.21	117.29	8962.0
2010-03-25 06:00:00	SPY	ETF	117.31	117.36	117.3	117.3	650.0
2010-03-25 07:00:00	SPY	ETF	117.29	117.45	117.29	117.45	87000.0
2010-03-25 07:30:00	SPY	ETF	117.47	117.5	117.42	117.46	269640.0
2010-03-25 08:00:00	SPY	ETF	117.45	117.52	117.2	117.43	1121094.0
2010-03-25 08:30:00	SPY	ETF	117.44	117.51	117.36	117.47	2054121.0
2010-03-25 09:00:00	SPY	ETF	117.48	117.7	117.47	117.64	1623316.0
2010-03-25 09:30:00	SPY	ETF	117.63	117.73	117.39	117.48	20394435.0
2010-03-25 10:00:00	SPY	ETF	117.48	117.65	117.24	117.45	16186663.0
2010-03-25 10:30:00	SPY	ETF	117.45	117.6	117.42	117.535	11363339.0
2010-03-25 11:00:00	SPY	ETF	117.53	117.95	117.53	117.91	15792160.0
2010-03-25 11:30:00	SPY	ETF	117.92	118.04	117.91	117.9699	11336563.0
2010-03-25 12:00:00	SPY	ETF	117.97	118.04	117.77	117.86	11290956.0
2010-03-25 12:30:00	SPY	ETF	117.86	118.1666	117.86	117.9701	7772988.0
2010-03-25 13:00:00	SPY	ETF	117.97	118.06	117.87	117.93	8759294.0
2010-03-25 13:30:00	SPY	ETF	117.93	117.94	116.7812	117.48	23157962.0
2010-03-25 14:00:00	SPY	ETF	117.47	117.6	117.17	117.218	13560218.0
2010-03-25 14:30:00	SPY	ETF	117.22	117.53	117.05	117.27	14911056.0
2010-03-25 15:00:00	SPY	ETF	117.28	117.56	117.25	117.25	12086918.0
2010-03-25 15:30:00	SPY	ETF	117.26	117.44	116.51	116.64	38776292.0
2010-03-25 16:00:00	SPY	ETF	116.63	117.92	116.57	116.7	8291781.0
2010-03-25 16:30:00	SPY	ETF	116.7	116.71	116.46	116.53	3357115.0
2010-03-25 17:00:00	SPY	ETF	116.53	116.53	116.4	116.44	510974.0
2010-03-25 17:30:00	SPY	ETF	116.44	116.5797	116.44	116.45	435454.0
2010-03-25 18:00:00	SPY	ETF	116.48	116.5	116.44	116.46	79196.0
2010-03-25 18:30:00	SPY	ETF	116.45	116.53	116.43	116.43	25265.0
2010-03-25 19:00:00	SPY	ETF	116.46	116.47	116.44	116.44	10640.0
2010-03-25 19:30:00	SPY	ETF	116.43	116.49	116.29	116.45	93929.0
2010-03-25 04:00:00	QQQ	ETF	48.13	48.13	48.13	48.13	211.0
2010-03-25 05:30:00	QQQ	ETF	48.19	48.19	48.19	48.19	300.0
2010-03-25 06:00:00	QQQ	ETF	48.22	48.22	48.2	48.2	950.0
2010-03-25 07:00:00	QQQ	ETF	48.22	48.24	48.22	48.24	28987.0
2010-03-25 07:30:00	QQQ	ETF	48.26	48.26	48.22	48.23	11696.0
2010-03-25 08:00:00	QQQ	ETF	48.24	48.28	48.24	48.24	118101.0
2010-03-25 08:30:00	QQQ	ETF	48.25	48.28	48.22	48.27	520203.0
2010-03-25 09:00:00	QQQ	ETF	48.27	48.42	48.27	48.41	1697894.0
2010-03-25 09:30:00	QQQ	ETF	48.42	48.45	48.27	48.329	10291869.0
2010-03-25 10:00:00	QQQ	ETF	48.3299	48.43	48.2	48.33	6225921.0
2010-03-25 10:30:00	QQQ	ETF	48.33	48.39	48.285	48.35	4403471.0
2010-03-25 11:00:00	QQQ	ETF	48.35	48.54	48.34	48.52	4801930.0
2010-03-25 11:30:00	QQQ	ETF	48.53	48.6	48.53	48.551	5472892.0
2010-03-25 12:00:00	QQQ	ETF	48.5599	48.56	48.43	48.4599	2609825.0
2010-03-25 12:30:00	QQQ	ETF	48.45	48.54	48.45	48.4705	1708624.0
2010-03-25 13:00:00	QQQ	ETF	48.4785	48.54	48.46	48.49	1972510.0
2010-03-25 13:30:00	QQQ	ETF	48.495	48.5	48.27	48.31	5946714.0
2010-03-25 14:00:00	QQQ	ETF	48.3119	48.35	48.12	48.14	4553489.0
2010-03-25 14:30:00	QQQ	ETF	48.14	48.23	48.08	48.18	4715346.0
2010-03-25 15:00:00	QQQ	ETF	48.1701	48.34	48.17	48.2	3953101.0

> showing 50 of 8,653 rows — these rows as CSV

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