PREVIEW / etf_30min / 2010-09-02

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-02.parquet
  size:    253 KB
  rows:    8,417

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-09-02 04:00:00	SPY	ETF	108.42	108.65	108.35	108.65	1720.0
2010-09-02 04:30:00	SPY	ETF	108.56	108.56	108.46	108.46	200.0
2010-09-02 05:30:00	SPY	ETF	108.68	108.73	108.68	108.73	1400.0
2010-09-02 06:00:00	SPY	ETF	108.65	108.65	108.46	108.56	16100.0
2010-09-02 06:30:00	SPY	ETF	108.52	108.56	108.51	108.51	67895.0
2010-09-02 07:00:00	SPY	ETF	108.59	109.01	108.57	108.88	254111.0
2010-09-02 07:30:00	SPY	ETF	108.88	108.89	108.65	108.78	306066.0
2010-09-02 08:00:00	SPY	ETF	108.73	108.89	108.39	108.71	523920.0
2010-09-02 08:30:00	SPY	ETF	108.79	108.98	108.65	108.84	2022532.0
2010-09-02 09:00:00	SPY	ETF	108.83	108.89	108.71	108.72	1153164.0
2010-09-02 09:30:00	SPY	ETF	108.72	108.95	108.49	108.9	22536542.0
2010-09-02 10:00:00	SPY	ETF	108.91	109.15	108.66	108.94	23185565.0
2010-09-02 10:30:00	SPY	ETF	108.95	109.1205	108.82	109.07	11993432.0
2010-09-02 11:00:00	SPY	ETF	109.07	109.2	108.72	108.82	11763924.0
2010-09-02 11:30:00	SPY	ETF	108.81	109.05	108.78	108.95	7540956.0
2010-09-02 12:00:00	SPY	ETF	108.95	109.1	108.91	109.0	5200007.0
2010-09-02 12:30:00	SPY	ETF	109.0	109.07	108.82	108.84	6548878.0
2010-09-02 13:00:00	SPY	ETF	108.84	109.01	108.78	108.81	4162379.0
2010-09-02 13:30:00	SPY	ETF	108.8	108.99	108.79	108.96	3078731.0
2010-09-02 14:00:00	SPY	ETF	108.96	109.26	108.92	109.07	8813746.0
2010-09-02 14:30:00	SPY	ETF	109.07	109.14	109.03	109.111	4474275.0
2010-09-02 15:00:00	SPY	ETF	109.11	109.25	109.02	109.218	10585344.0
2010-09-02 15:30:00	SPY	ETF	109.22	109.49	109.19	109.46	23243795.0
2010-09-02 16:00:00	SPY	ETF	109.46	109.59	108.615	109.52	4931435.0
2010-09-02 16:30:00	SPY	ETF	109.52	109.56	109.5	109.5	324546.0
2010-09-02 17:00:00	SPY	ETF	109.5	109.51	109.42	109.47	215038.0
2010-09-02 17:30:00	SPY	ETF	109.48	109.55	109.41	109.42	1101446.0
2010-09-02 18:00:00	SPY	ETF	109.44	109.47	109.41	109.46	59795.0
2010-09-02 18:30:00	SPY	ETF	109.45	109.47	109.45	109.45	8976.0
2010-09-02 19:00:00	SPY	ETF	109.46	109.46	109.34	109.36	78220.0
2010-09-02 19:30:00	SPY	ETF	109.35	109.38	109.31	109.36	43624.0
2010-09-02 04:00:00	QQQ	ETF	44.71	44.8	44.71	44.8	5200.0
2010-09-02 04:30:00	QQQ	ETF	44.72	44.72	44.72	44.72	245.0
2010-09-02 05:00:00	QQQ	ETF	44.71	44.74	44.71	44.74	4700.0
2010-09-02 05:30:00	QQQ	ETF	44.82	44.82	44.82	44.82	400.0
2010-09-02 06:30:00	QQQ	ETF	44.72	44.75	44.72	44.74	4978.0
2010-09-02 07:00:00	QQQ	ETF	44.75	44.94	44.75	44.92	3013.0
2010-09-02 07:30:00	QQQ	ETF	44.78	44.79	44.78	44.79	2640.0
2010-09-02 08:00:00	QQQ	ETF	44.81	44.87	44.76	44.8	158767.0
2010-09-02 08:30:00	QQQ	ETF	44.82	44.91	44.81	44.87	293144.0
2010-09-02 09:00:00	QQQ	ETF	44.87	44.88	44.8	44.84	196261.0
2010-09-02 09:30:00	QQQ	ETF	44.84	44.97	44.73	44.95	6031164.0
2010-09-02 10:00:00	QQQ	ETF	44.955	45.05	44.84	45.0	5365083.0
2010-09-02 10:30:00	QQQ	ETF	45.01	45.1	44.95	45.08	3259256.0
2010-09-02 11:00:00	QQQ	ETF	45.085	45.135	44.99	45.02	2711033.0
2010-09-02 11:30:00	QQQ	ETF	45.01	45.11	45.0	45.07	1599669.0
2010-09-02 12:00:00	QQQ	ETF	45.08	45.14	45.06	45.1003	1124247.0
2010-09-02 12:30:00	QQQ	ETF	45.11	45.14	44.99	45.02	4047071.0
2010-09-02 13:00:00	QQQ	ETF	45.023	45.05	44.9901	45.01	879488.0
2010-09-02 13:30:00	QQQ	ETF	45.01	45.08	45.0	45.07	957343.0

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

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