PREVIEW / etf_30min / 2009-06-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-02.parquet
  size:    221 KB
  rows:    7,460

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-06-02 04:00:00	SPY	ETF	94.26	94.26	94.05	94.22	700.0
2009-06-02 04:30:00	SPY	ETF	94.24	94.24	94.24	94.24	600.0
2009-06-02 05:00:00	SPY	ETF	94.18	94.25	94.11	94.21	8732.0
2009-06-02 05:30:00	SPY	ETF	94.37	94.5	94.28	94.49	35100.0
2009-06-02 06:00:00	SPY	ETF	94.56	94.59	94.56	94.59	7300.0
2009-06-02 06:30:00	SPY	ETF	94.41	94.72	94.41	94.72	36800.0
2009-06-02 07:00:00	SPY	ETF	94.59	94.7	94.42	94.51	201783.0
2009-06-02 07:30:00	SPY	ETF	94.53	94.7	94.43	94.69	415512.0
2009-06-02 08:00:00	SPY	ETF	94.69	94.71	94.05	94.27	1196786.0
2009-06-02 08:30:00	SPY	ETF	94.28	94.49	94.04	94.41	1731318.0
2009-06-02 09:00:00	SPY	ETF	94.41	94.44	94.19	94.4	1510945.0
2009-06-02 09:30:00	SPY	ETF	94.4	94.88	87.53	94.88	27961024.0
2009-06-02 10:00:00	SPY	ETF	94.85	95.37	94.72	95.06	37652666.0
2009-06-02 10:30:00	SPY	ETF	95.0522	95.23	87.97	94.85	18326782.0
2009-06-02 11:00:00	SPY	ETF	94.8483	95.0	94.73	94.842	12684936.0
2009-06-02 11:30:00	SPY	ETF	94.84	94.9	94.47	94.6094	14983106.0
2009-06-02 12:00:00	SPY	ETF	94.6	94.76	94.41	94.45	14065432.0
2009-06-02 12:30:00	SPY	ETF	94.4501	94.76	94.41	94.672	6027129.0
2009-06-02 13:00:00	SPY	ETF	94.68	94.85	94.56	94.8	8317304.0
2009-06-02 13:30:00	SPY	ETF	94.79	95.01	94.65	94.9301	10031301.0
2009-06-02 14:00:00	SPY	ETF	94.94	95.18	94.72	95.04	12971238.0
2009-06-02 14:30:00	SPY	ETF	95.04	95.2	94.93	94.94	9477901.0
2009-06-02 15:00:00	SPY	ETF	94.96	95.22	94.91	94.969	18866375.0
2009-06-02 15:30:00	SPY	ETF	94.9678	95.19	94.76	94.86	23397102.0
2009-06-02 16:00:00	SPY	ETF	94.87	95.1692	94.61	94.75	7303215.0
2009-06-02 16:30:00	SPY	ETF	94.77	94.77	94.55	94.65	2437949.0
2009-06-02 17:00:00	SPY	ETF	94.65	94.67	94.63	94.65	13058.0
2009-06-02 17:30:00	SPY	ETF	94.66	94.87	94.65	94.71	249521.0
2009-06-02 18:00:00	SPY	ETF	94.7	94.7	94.51	94.52	212966.0
2009-06-02 18:30:00	SPY	ETF	94.52	94.57	94.5	94.53	53279.0
2009-06-02 19:00:00	SPY	ETF	94.53	94.55	94.49	94.49	46425.0
2009-06-02 19:30:00	SPY	ETF	94.5	94.57	94.5	94.54	34730.0
2009-06-02 04:00:00	QQQ	ETF	36.21	36.21	36.17	36.17	1100.0
2009-06-02 06:00:00	QQQ	ETF	36.3	36.3	36.3	36.3	300.0
2009-06-02 06:30:00	QQQ	ETF	36.25	36.33	36.25	36.3	4106.0
2009-06-02 07:00:00	QQQ	ETF	36.28	36.34	36.27	36.3	79497.0
2009-06-02 07:30:00	QQQ	ETF	36.28	36.34	36.28	36.33	58629.0
2009-06-02 08:00:00	QQQ	ETF	36.32	36.33	36.0	36.18	203141.0
2009-06-02 08:30:00	QQQ	ETF	36.18	36.19	36.1	36.17	310166.0
2009-06-02 09:00:00	QQQ	ETF	36.17	36.2	36.11	36.19	520183.0
2009-06-02 09:30:00	QQQ	ETF	36.19	36.52	36.11	36.52	14585374.0
2009-06-02 10:00:00	QQQ	ETF	36.48	36.79	36.47	36.58	23516317.0
2009-06-02 10:30:00	QQQ	ETF	36.5795	36.62	36.38	36.4267	7478350.0
2009-06-02 11:00:00	QQQ	ETF	36.42	36.54	36.4199	36.49	7472932.0
2009-06-02 11:30:00	QQQ	ETF	36.49	36.51	36.32	36.37	6408866.0
2009-06-02 12:00:00	QQQ	ETF	36.38	36.43	36.26	36.27	7310933.0
2009-06-02 12:30:00	QQQ	ETF	36.28	36.43	36.25	36.4	3924949.0
2009-06-02 13:00:00	QQQ	ETF	36.3999	36.44	36.3	36.43	5064984.0
2009-06-02 13:30:00	QQQ	ETF	36.43	36.49	36.41	36.49	3952205.0
2009-06-02 14:00:00	QQQ	ETF	36.48	36.55	36.41	36.53	5487020.0

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

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