PREVIEW / etf_30min / 2010-03-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-26.parquet
  size:    251 KB
  rows:    8,295

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-26 04:00:00	SPY	ETF	116.96	116.96	116.96	116.96	305.0
2010-03-26 04:30:00	SPY	ETF	116.9	116.9	116.9	116.9	100.0
2010-03-26 06:00:00	SPY	ETF	117.02	117.05	117.01	117.01	1260.0
2010-03-26 06:30:00	SPY	ETF	117.03	117.03	117.01	117.03	8000.0
2010-03-26 07:00:00	SPY	ETF	116.97	117.13	116.97	117.07	217720.0
2010-03-26 07:30:00	SPY	ETF	117.07	117.08	116.95	117.06	215294.0
2010-03-26 08:00:00	SPY	ETF	117.06	117.28	116.8	117.07	3523018.0
2010-03-26 08:30:00	SPY	ETF	117.06	117.1	116.93	117.03	856810.0
2010-03-26 09:00:00	SPY	ETF	117.02	117.1	116.83	116.87	1685657.0
2010-03-26 09:30:00	SPY	ETF	116.87	117.15	116.71	117.01	23487317.0
2010-03-26 10:00:00	SPY	ETF	117.01	117.36	117.0	117.32	19163315.0
2010-03-26 10:30:00	SPY	ETF	117.31	117.42	117.1	117.16	12416983.0
2010-03-26 11:00:00	SPY	ETF	117.16	117.34	117.13	117.27	9251992.0
2010-03-26 11:30:00	SPY	ETF	117.27	117.34	117.1	117.13	9767843.0
2010-03-26 12:00:00	SPY	ETF	117.13	117.22	116.685	116.75	12382894.0
2010-03-26 12:30:00	SPY	ETF	116.75	116.8	116.4	116.52	17620186.0
2010-03-26 13:00:00	SPY	ETF	116.52	116.582	116.12	116.43	17938837.0
2010-03-26 13:30:00	SPY	ETF	116.43	116.62	116.34	116.44	10916100.0
2010-03-26 14:00:00	SPY	ETF	116.44	116.73	116.25	116.71	13966244.0
2010-03-26 14:30:00	SPY	ETF	116.71	116.83	116.5	116.57	8765308.0
2010-03-26 15:00:00	SPY	ETF	116.56	116.64	116.41	116.54	8011701.0
2010-03-26 15:30:00	SPY	ETF	116.54	116.71	116.45	116.65	18367398.0
2010-03-26 16:00:00	SPY	ETF	116.66	117.2538	116.582	116.82	12860766.0
2010-03-26 16:30:00	SPY	ETF	116.83	116.83	116.6697	116.8	2768777.0
2010-03-26 17:00:00	SPY	ETF	116.8	116.81	116.77	116.77	74783.0
2010-03-26 17:30:00	SPY	ETF	116.8	116.81	116.78	116.8	18992.0
2010-03-26 18:00:00	SPY	ETF	116.78	116.81	116.77	116.79	25061.0
2010-03-26 18:30:00	SPY	ETF	116.81	116.81	116.78	116.8	2334.0
2010-03-26 19:00:00	SPY	ETF	116.81	116.84	116.81	116.84	2500.0
2010-03-26 19:30:00	SPY	ETF	116.84	117.31	116.84	117.3	152903.0
2010-03-26 05:30:00	QQQ	ETF	48.14	48.14	48.13	48.13	13500.0
2010-03-26 06:00:00	QQQ	ETF	48.08	48.11	48.08	48.11	5100.0
2010-03-26 06:30:00	QQQ	ETF	48.1	48.11	48.1	48.11	2960.0
2010-03-26 07:00:00	QQQ	ETF	48.09	48.22	48.09	48.21	1092196.0
2010-03-26 07:30:00	QQQ	ETF	48.19	48.19	48.14	48.19	58626.0
2010-03-26 08:00:00	QQQ	ETF	48.18	48.24	48.11	48.11	1242867.0
2010-03-26 08:30:00	QQQ	ETF	48.11	48.16	48.06	48.13	288339.0
2010-03-26 09:00:00	QQQ	ETF	48.13	48.15	48.05	48.13	522572.0
2010-03-26 09:30:00	QQQ	ETF	48.14	48.27	48.06	48.16	9561759.0
2010-03-26 10:00:00	QQQ	ETF	48.16	48.33	48.16	48.29	7495321.0
2010-03-26 10:30:00	QQQ	ETF	48.29	48.33	48.13	48.15	4921623.0
2010-03-26 11:00:00	QQQ	ETF	48.15	48.25	48.13	48.21	2666894.0
2010-03-26 11:30:00	QQQ	ETF	48.21	48.25	48.14	48.15	2633883.0
2010-03-26 12:00:00	QQQ	ETF	48.1501	48.2	47.9626	47.98	4611502.0
2010-03-26 12:30:00	QQQ	ETF	47.97	48.01	47.84	47.86	6410088.0
2010-03-26 13:00:00	QQQ	ETF	47.8699	47.9	47.74	47.85	5479548.0
2010-03-26 13:30:00	QQQ	ETF	47.85	47.92	47.79	47.82	4392736.0
2010-03-26 14:00:00	QQQ	ETF	47.81	47.99	47.75	47.9799	6495650.0
2010-03-26 14:30:00	QQQ	ETF	47.97	48.02	47.9	47.9275	2729741.0
2010-03-26 15:00:00	QQQ	ETF	47.93	47.96	47.874	47.91	2394452.0

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

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