PREVIEW / etf_30min / 2009-02-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-23.parquet
  size:    213 KB
  rows:    7,124

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-02-23 04:00:00	SPY	ETF	78.66	78.66	78.55	78.58	18300.0
2009-02-23 04:30:00	SPY	ETF	78.61	78.85	78.61	78.85	2973.0
2009-02-23 05:00:00	SPY	ETF	78.9	78.94	78.83	78.94	25200.0
2009-02-23 05:30:00	SPY	ETF	78.71	78.71	78.41	78.41	6050.0
2009-02-23 06:00:00	SPY	ETF	78.49	78.51	78.26	78.35	41093.0
2009-02-23 06:30:00	SPY	ETF	78.34	78.5	78.22	78.43	40688.0
2009-02-23 07:00:00	SPY	ETF	78.37	78.37	77.94	77.94	739228.0
2009-02-23 07:30:00	SPY	ETF	77.96	78.1	77.68	78.04	821302.0
2009-02-23 08:00:00	SPY	ETF	77.86	78.72	77.84	78.17	2820181.0
2009-02-23 08:30:00	SPY	ETF	78.18	78.56	78.16	78.51	1521762.0
2009-02-23 09:00:00	SPY	ETF	78.51	78.51	78.18	78.25	1748737.0
2009-02-23 09:30:00	SPY	ETF	78.27	78.27	77.42	77.55	34605268.0
2009-02-23 10:00:00	SPY	ETF	77.55	77.63	76.91	77.06	27844178.0
2009-02-23 10:30:00	SPY	ETF	77.06	77.07	76.33	76.35	27351157.0
2009-02-23 11:00:00	SPY	ETF	76.36	76.71	76.33	76.55	17255540.0
2009-02-23 11:30:00	SPY	ETF	76.54	76.55	76.05	76.21	17393531.0
2009-02-23 12:00:00	SPY	ETF	76.21	76.24	76.0	76.06	13246485.0
2009-02-23 12:30:00	SPY	ETF	76.07	76.07	75.33	75.36	22390170.0
2009-02-23 13:00:00	SPY	ETF	75.36	75.87	75.31	75.69	21655002.0
2009-02-23 13:30:00	SPY	ETF	75.6899	77.725	75.5	75.601	21839289.0
2009-02-23 14:00:00	SPY	ETF	75.59	76.2	75.4	76.17	24847016.0
2009-02-23 14:30:00	SPY	ETF	76.16	76.22	75.02	75.03	31332553.0
2009-02-23 15:00:00	SPY	ETF	75.04	75.49	74.67	74.95	37885038.0
2009-02-23 15:30:00	SPY	ETF	74.95	75.35	74.59	74.78	50084540.0
2009-02-23 16:00:00	SPY	ETF	74.73	75.56	74.47	75.0	10695404.0
2009-02-23 16:30:00	SPY	ETF	74.99	75.01	74.7	74.94	5060839.0
2009-02-23 17:00:00	SPY	ETF	74.93	78.2	74.9	75.07	1446419.0
2009-02-23 17:30:00	SPY	ETF	75.06	75.12	74.93	75.12	335203.0
2009-02-23 18:00:00	SPY	ETF	75.11	75.19	75.01	75.17	258998.0
2009-02-23 18:30:00	SPY	ETF	75.12	75.17	75.01	75.01	146077.0
2009-02-23 19:00:00	SPY	ETF	75.01	75.2	74.98	75.17	107894.0
2009-02-23 19:30:00	SPY	ETF	75.14	75.32	75.12	75.19	45526.0
2009-02-23 04:00:00	QQQ	ETF	29.3	29.33	29.3	29.33	3040.0
2009-02-23 04:30:00	QQQ	ETF	29.33	29.4	29.33	29.4	400.0
2009-02-23 05:00:00	QQQ	ETF	29.41	29.43	29.41	29.43	1112.0
2009-02-23 05:30:00	QQQ	ETF	29.33	29.33	29.33	29.33	100.0
2009-02-23 06:00:00	QQQ	ETF	29.18	29.18	29.17	29.17	1400.0
2009-02-23 06:30:00	QQQ	ETF	29.2	29.2	29.15	29.15	200.0
2009-02-23 07:00:00	QQQ	ETF	29.23	29.23	29.07	29.07	28220.0
2009-02-23 07:30:00	QQQ	ETF	29.07	29.12	28.98	29.11	201641.0
2009-02-23 08:00:00	QQQ	ETF	29.05	29.18	29.05	29.13	381096.0
2009-02-23 08:30:00	QQQ	ETF	29.14	29.25	29.11	29.18	1098704.0
2009-02-23 09:00:00	QQQ	ETF	29.17	29.17	29.04	29.04	397611.0
2009-02-23 09:30:00	QQQ	ETF	29.03	29.05	28.61	28.64	16197799.0
2009-02-23 10:00:00	QQQ	ETF	28.6405	28.68	28.4	28.51	13392087.0
2009-02-23 10:30:00	QQQ	ETF	28.5118	28.53	28.35	28.36	9886508.0
2009-02-23 11:00:00	QQQ	ETF	28.36	28.49	28.34	28.39	7927973.0
2009-02-23 11:30:00	QQQ	ETF	28.39	28.39	28.17	28.22	8589977.0
2009-02-23 12:00:00	QQQ	ETF	28.22	28.28	28.13	28.2205	7539516.0
2009-02-23 12:30:00	QQQ	ETF	28.22	28.23	28.02	28.022	7491007.0

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

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