PREVIEW / etf_30min / 2008-05-02

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-02.parquet
  size:    168 KB
  rows:    5,764

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
2008-05-02 05:00:00	SPY	ETF	141.07	141.08	141.05	141.08	900.0
2008-05-02 05:30:00	SPY	ETF	141.08	141.11	141.07	141.07	15300.0
2008-05-02 06:00:00	SPY	ETF	141.12	141.24	141.12	141.24	65000.0
2008-05-02 06:30:00	SPY	ETF	141.09	141.16	141.05	141.16	65100.0
2008-05-02 07:00:00	SPY	ETF	141.17	141.34	141.13	141.34	570661.0
2008-05-02 07:30:00	SPY	ETF	141.33	141.4	141.23	141.26	467460.0
2008-05-02 08:00:00	SPY	ETF	141.26	141.74	141.04	141.58	4264649.0
2008-05-02 08:30:00	SPY	ETF	141.6	142.6	141.0	142.29	13781310.0
2008-05-02 09:00:00	SPY	ETF	142.25	142.41	142.16	142.33	1889683.0
2008-05-02 09:30:00	SPY	ETF	142.33	142.37	141.67	142.01	23663892.0
2008-05-02 10:00:00	SPY	ETF	142.01	142.3	141.55	141.61	14876420.0
2008-05-02 10:30:00	SPY	ETF	141.61	141.78	141.27	141.37	12888671.0
2008-05-02 11:00:00	SPY	ETF	141.3785	141.9	141.37	141.53	10458662.0
2008-05-02 11:30:00	SPY	ETF	141.54	141.72	141.37	141.49	8939968.0
2008-05-02 12:00:00	SPY	ETF	141.49	141.49	141.13	141.25	10673253.0
2008-05-02 12:30:00	SPY	ETF	141.25	141.2899	140.97	141.13	8866058.0
2008-05-02 13:00:00	SPY	ETF	141.14	141.17	140.62	140.99	10276205.0
2008-05-02 13:30:00	SPY	ETF	140.99	141.27	140.84	141.03	10093834.0
2008-05-02 14:00:00	SPY	ETF	141.03	141.4	140.56	140.77	13529931.0
2008-05-02 14:30:00	SPY	ETF	140.77	141.13	140.71	140.8	8345811.0
2008-05-02 15:00:00	SPY	ETF	140.81	141.29	140.75	141.15	9793707.0
2008-05-02 15:30:00	SPY	ETF	141.15	141.43	140.9	141.34	13362629.0
2008-05-02 16:00:00	SPY	ETF	141.35	142.124	140.83	141.57	2805815.0
2008-05-02 16:30:00	SPY	ETF	141.57	141.75	141.56	141.67	302466.0
2008-05-02 17:00:00	SPY	ETF	141.68	141.72	141.65	141.7	29451.0
2008-05-02 17:30:00	SPY	ETF	141.7	141.72	141.58	141.58	38100.0
2008-05-02 18:00:00	SPY	ETF	141.6	141.6	141.6	141.6	500.0
2008-05-02 18:30:00	SPY	ETF	141.72	141.72	141.72	141.72	4200.0
2008-05-02 19:00:00	SPY	ETF	141.68	141.73	141.61	141.66	12102.0
2008-05-02 19:30:00	SPY	ETF	141.66	141.66	141.65	141.65	7310.0
2008-05-02 04:00:00	QQQ	ETF	48.59	48.59	48.59	48.59	200.0
2008-05-02 06:30:00	QQQ	ETF	48.72	48.74	48.69	48.74	7000.0
2008-05-02 07:00:00	QQQ	ETF	48.71	48.77	48.7	48.74	11806.0
2008-05-02 07:30:00	QQQ	ETF	48.74	48.74	48.69	48.72	139677.0
2008-05-02 08:00:00	QQQ	ETF	48.71	48.8	48.57	48.8	1716750.0
2008-05-02 08:30:00	QQQ	ETF	48.62	49.27	48.6	49.18	7377508.0
2008-05-02 09:00:00	QQQ	ETF	49.18	49.22	49.06	49.19	3454148.0
2008-05-02 09:30:00	QQQ	ETF	49.18	49.19	48.77	48.9	17152931.0
2008-05-02 10:00:00	QQQ	ETF	48.9	49.1	48.75	48.76	15688213.0
2008-05-02 10:30:00	QQQ	ETF	48.76	48.82	48.51	48.55	12164146.0
2008-05-02 11:00:00	QQQ	ETF	48.55	48.78	48.55	48.6	6665652.0
2008-05-02 11:30:00	QQQ	ETF	48.61	48.72	48.57	48.592	4736538.0
2008-05-02 12:00:00	QQQ	ETF	48.59	48.62	48.48	48.56	6740950.0
2008-05-02 12:30:00	QQQ	ETF	48.56	48.59	48.47	48.55	5317413.0
2008-05-02 13:00:00	QQQ	ETF	48.56	48.57	48.34	48.5	6013478.0
2008-05-02 13:30:00	QQQ	ETF	48.5	48.6	48.42	48.5	4420104.0
2008-05-02 14:00:00	QQQ	ETF	48.5	48.59	48.362	48.39	6999926.0
2008-05-02 14:30:00	QQQ	ETF	48.39	48.51	48.36	48.4	4903986.0
2008-05-02 15:00:00	QQQ	ETF	48.4	48.63	48.37	48.59	5847577.0
2008-05-02 15:30:00	QQQ	ETF	48.59	48.75	48.53	48.74	9108364.0

> showing 50 of 5,764 rows — these rows as CSV

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