PREVIEW / etf_30min / 2009-05-01

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-01.parquet
  size:    208 KB
  rows:    6,914

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-05-01 04:00:00	SPY	ETF	87.7	87.7	87.7	87.7	1000.0
2009-05-01 04:30:00	SPY	ETF	87.73	87.73	87.73	87.73	100.0
2009-05-01 05:00:00	SPY	ETF	87.78	87.84	87.77	87.77	1200.0
2009-05-01 05:30:00	SPY	ETF	87.72	87.78	87.72	87.78	32650.0
2009-05-01 06:00:00	SPY	ETF	87.78	87.78	87.77	87.77	15600.0
2009-05-01 06:30:00	SPY	ETF	87.75	87.9	87.75	87.89	38236.0
2009-05-01 07:00:00	SPY	ETF	87.86	87.88	87.8	87.86	101610.0
2009-05-01 07:30:00	SPY	ETF	87.88	87.94	87.83	87.86	353901.0
2009-05-01 08:00:00	SPY	ETF	87.86	87.89	87.25	87.79	1643049.0
2009-05-01 08:30:00	SPY	ETF	87.8	87.9	87.42	87.73	668177.0
2009-05-01 09:00:00	SPY	ETF	87.73	87.73	87.28	87.45	3054381.0
2009-05-01 09:30:00	SPY	ETF	87.44	87.48	86.94	87.36	22859012.0
2009-05-01 10:00:00	SPY	ETF	87.3601	87.5	86.72	86.91	23768695.0
2009-05-01 10:30:00	SPY	ETF	86.9	87.3	86.79	87.16	11191007.0
2009-05-01 11:00:00	SPY	ETF	87.17	87.75	87.14	87.6	16710788.0
2009-05-01 11:30:00	SPY	ETF	87.6	87.68	87.33	87.37	11503055.0
2009-05-01 12:00:00	SPY	ETF	87.36	87.63	87.26	87.39	9026839.0
2009-05-01 12:30:00	SPY	ETF	87.38	87.72	87.29	87.59	11830493.0
2009-05-01 13:00:00	SPY	ETF	87.6	87.89	87.51	87.88	9972014.0
2009-05-01 13:30:00	SPY	ETF	87.89	88.21	87.83	87.89	12760474.0
2009-05-01 14:00:00	SPY	ETF	87.89	88.06	87.78	87.8275	11858039.0
2009-05-01 14:30:00	SPY	ETF	87.83	87.9	87.61	87.68	8456957.0
2009-05-01 15:00:00	SPY	ETF	87.68	87.91	87.25	87.31	19774051.0
2009-05-01 15:30:00	SPY	ETF	87.31	87.9	87.13	87.86	31147403.0
2009-05-01 16:00:00	SPY	ETF	87.84	88.27	87.5122	88.07	13645168.0
2009-05-01 16:30:00	SPY	ETF	88.05	88.1	88.04	88.09	135306.0
2009-05-01 17:00:00	SPY	ETF	88.07	88.07	88.04	88.05	70579.0
2009-05-01 17:30:00	SPY	ETF	88.05	88.05	87.99	88.02	53790.0
2009-05-01 18:00:00	SPY	ETF	88.03	88.2	86.7306	88.07	407655.0
2009-05-01 18:30:00	SPY	ETF	88.08	88.1	88.04	88.07	14846.0
2009-05-01 19:00:00	SPY	ETF	88.1	88.15	88.09	88.1	15961.0
2009-05-01 19:30:00	SPY	ETF	88.09	88.17	88.05	88.16	12127.0
2009-05-01 04:00:00	QQQ	ETF	34.42	34.42	34.42	34.42	400.0
2009-05-01 04:30:00	QQQ	ETF	34.46	34.46	34.46	34.46	1500.0
2009-05-01 05:30:00	QQQ	ETF	34.43	34.43	34.43	34.43	100.0
2009-05-01 06:00:00	QQQ	ETF	34.43	34.43	34.43	34.43	1000.0
2009-05-01 07:00:00	QQQ	ETF	34.46	34.48	34.46	34.47	5100.0
2009-05-01 07:30:00	QQQ	ETF	34.46	34.5	34.43	34.44	194846.0
2009-05-01 08:00:00	QQQ	ETF	34.43	34.45	34.37	34.37	1097884.0
2009-05-01 08:30:00	QQQ	ETF	34.37	34.38	34.33	34.35	88233.0
2009-05-01 09:00:00	QQQ	ETF	34.34	34.35	34.24	34.27	443978.0
2009-05-01 09:30:00	QQQ	ETF	34.28	34.33	34.08	34.21	10068092.0
2009-05-01 10:00:00	QQQ	ETF	34.21	34.28	34.01	34.08	12542755.0
2009-05-01 10:30:00	QQQ	ETF	34.08	34.2	34.04	34.17	4826012.0
2009-05-01 11:00:00	QQQ	ETF	34.17	34.34	34.15	34.2701	4629812.0
2009-05-01 11:30:00	QQQ	ETF	34.27	34.3	34.15	34.1601	4312368.0
2009-05-01 12:00:00	QQQ	ETF	34.16	34.32	34.14	34.247	3724248.0
2009-05-01 12:30:00	QQQ	ETF	34.24	34.38	34.21	34.345	3772111.0
2009-05-01 13:00:00	QQQ	ETF	34.34	34.43	34.31	34.43	3765828.0
2009-05-01 13:30:00	QQQ	ETF	34.43	34.54	34.4	34.44	6132757.0

> showing 50 of 6,914 rows — these rows as CSV

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