PREVIEW / etf_30min / 2009-12-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-02.parquet
  size:    233 KB
  rows:    7,817

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
2009-12-02 04:00:00	SPY	ETF	111.22	111.22	111.18	111.18	239.0
2009-12-02 04:30:00	SPY	ETF	111.34	111.34	111.34	111.34	100.0
2009-12-02 05:00:00	SPY	ETF	111.38	111.42	111.38	111.42	200.0
2009-12-02 05:30:00	SPY	ETF	111.23	111.35	111.23	111.35	2500.0
2009-12-02 06:00:00	SPY	ETF	111.23	111.23	111.08	111.08	900.0
2009-12-02 06:30:00	SPY	ETF	111.21	111.21	111.21	111.21	500.0
2009-12-02 07:00:00	SPY	ETF	111.2	111.4	111.15	111.26	584793.0
2009-12-02 07:30:00	SPY	ETF	111.24	111.4	111.21	111.38	1049561.0
2009-12-02 08:00:00	SPY	ETF	111.35	111.57	111.16	111.29	3257676.0
2009-12-02 08:30:00	SPY	ETF	111.29	111.39	111.18	111.21	1046636.0
2009-12-02 09:00:00	SPY	ETF	111.22	111.28	111.16	111.28	550344.0
2009-12-02 09:30:00	SPY	ETF	111.28	111.58	111.21	111.43	15819134.0
2009-12-02 10:00:00	SPY	ETF	111.42	112.01	111.42	111.84	15429855.0
2009-12-02 10:30:00	SPY	ETF	111.84	111.84	111.68	111.75	9820356.0
2009-12-02 11:00:00	SPY	ETF	111.745	111.75	111.22	111.33	11976040.0
2009-12-02 11:30:00	SPY	ETF	111.34	111.48	111.31	111.38	4981503.0
2009-12-02 12:00:00	SPY	ETF	111.37	111.44	110.92	111.06	7424796.0
2009-12-02 12:30:00	SPY	ETF	111.06	111.19	111.01	111.19	4173079.0
2009-12-02 13:00:00	SPY	ETF	111.19	111.4	111.09	111.16	3813432.0
2009-12-02 13:30:00	SPY	ETF	111.16	111.4	111.1	111.24	4197595.0
2009-12-02 14:00:00	SPY	ETF	111.24	111.37	110.99	111.18	10137234.0
2009-12-02 14:30:00	SPY	ETF	111.18	111.32	111.12	111.185	7897354.0
2009-12-02 15:00:00	SPY	ETF	111.19	111.27	111.09	111.21	5189525.0
2009-12-02 15:30:00	SPY	ETF	111.21	111.46	111.12	111.31	14617212.0
2009-12-02 16:00:00	SPY	ETF	111.3	111.88	111.1	111.26	4711284.0
2009-12-02 16:30:00	SPY	ETF	111.26	111.3	111.24	111.27	137899.0
2009-12-02 17:00:00	SPY	ETF	111.27	111.37	111.11	111.3	231128.0
2009-12-02 17:30:00	SPY	ETF	111.25	111.5	111.25	111.46	573191.0
2009-12-02 18:00:00	SPY	ETF	111.44	111.52	111.37	111.47	183214.0
2009-12-02 18:30:00	SPY	ETF	111.48	111.65	111.46	111.56	132850.0
2009-12-02 19:00:00	SPY	ETF	111.55	111.58	111.41	111.45	78730.0
2009-12-02 19:30:00	SPY	ETF	111.48	111.56	111.46	111.56	76801.0
2009-12-02 06:30:00	QQQ	ETF	44.03	44.03	44.03	44.03	300.0
2009-12-02 07:00:00	QQQ	ETF	44.08	44.16	44.04	44.07	195600.0
2009-12-02 07:30:00	QQQ	ETF	44.08	44.1	44.07	44.1	949022.0
2009-12-02 08:00:00	QQQ	ETF	44.08	44.17	44.07	44.12	3177624.0
2009-12-02 08:30:00	QQQ	ETF	44.11	44.15	44.08	44.08	1566255.0
2009-12-02 09:00:00	QQQ	ETF	44.09	44.16	44.08	44.16	114207.0
2009-12-02 09:30:00	QQQ	ETF	44.16	44.31	44.1178	44.25	11411668.0
2009-12-02 10:00:00	QQQ	ETF	44.25	44.49	44.15	44.47	10797690.0
2009-12-02 10:30:00	QQQ	ETF	44.47	44.485	44.36	44.421	5794851.0
2009-12-02 11:00:00	QQQ	ETF	44.42	44.44	44.21	44.25	5942526.0
2009-12-02 11:30:00	QQQ	ETF	44.241	44.29	44.2	44.21	2478267.0
2009-12-02 12:00:00	QQQ	ETF	44.22	44.25	44.01	44.08	4522733.0
2009-12-02 12:30:00	QQQ	ETF	44.08	44.13	44.04	44.13	1256615.0
2009-12-02 13:00:00	QQQ	ETF	44.1299	44.13	44.06	44.07	1905314.0
2009-12-02 13:30:00	QQQ	ETF	44.06	44.16	44.03	44.1299	2867158.0
2009-12-02 14:00:00	QQQ	ETF	44.129	44.19	43.98	44.06	8166725.0
2009-12-02 14:30:00	QQQ	ETF	44.05	44.14	44.0367	44.1	3953213.0
2009-12-02 15:00:00	QQQ	ETF	44.1	44.13	44.04	44.08	3763114.0

> showing 50 of 7,817 rows — these rows as CSV

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