PREVIEW / etf_30min / 2007-04-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-02.parquet
  size:    103 KB
  rows:    3,620

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
2007-04-02 04:00:00	SPY	ETF	142.04	142.04	142.04	142.04	2200.0
2007-04-02 06:00:00	SPY	ETF	142.05	142.05	142.05	142.05	5000.0
2007-04-02 06:30:00	SPY	ETF	142.03	142.03	142.03	142.03	7500.0
2007-04-02 07:00:00	SPY	ETF	142.02	142.02	141.96	142.02	55400.0
2007-04-02 07:30:00	SPY	ETF	142.03	142.23	142.02	142.11	280800.0
2007-04-02 08:00:00	SPY	ETF	142.2	142.2	142.07	142.13	199000.0
2007-04-02 08:30:00	SPY	ETF	142.13	142.19	142.0	142.18	924600.0
2007-04-02 09:00:00	SPY	ETF	142.18	142.22	142.0	142.16	241100.0
2007-04-02 09:30:00	SPY	ETF	142.16	142.34	142.03	142.13	6797400.0
2007-04-02 10:00:00	SPY	ETF	142.14	142.23	140.89	141.68	17027764.0
2007-04-02 10:30:00	SPY	ETF	141.68	142.1	141.64	142.06	8494185.0
2007-04-02 11:00:00	SPY	ETF	142.05	142.44	142.01	142.15	5165787.0
2007-04-02 11:30:00	SPY	ETF	142.15	142.24	141.95	142.01	3217815.0
2007-04-02 12:00:00	SPY	ETF	142.01	142.16	141.97	142.06	3971300.0
2007-04-02 12:30:00	SPY	ETF	142.07	142.17	141.9	141.95	3274800.0
2007-04-02 13:00:00	SPY	ETF	141.95	142.15	141.87	142.03	3604875.0
2007-04-02 13:30:00	SPY	ETF	142.02	142.05	141.93	141.95	1612300.0
2007-04-02 14:00:00	SPY	ETF	141.96	142.14	141.76	142.02	5141900.0
2007-04-02 14:30:00	SPY	ETF	142.02	142.18	142.02	142.1	3032851.0
2007-04-02 15:00:00	SPY	ETF	142.1	142.46	142.1	142.37	7572443.0
2007-04-02 15:30:00	SPY	ETF	142.38	142.4	142.22	142.3	5296060.0
2007-04-02 16:00:00	SPY	ETF	142.3	142.34	142.1655	142.2	1645700.0
2007-04-02 16:30:00	SPY	ETF	142.21	142.33	142.19	142.27	143600.0
2007-04-02 17:00:00	SPY	ETF	142.27	142.28	142.22	142.28	83900.0
2007-04-02 17:30:00	SPY	ETF	142.28	142.28	142.23	142.24	9200.0
2007-04-02 18:00:00	SPY	ETF	142.24	142.28	142.24	142.24	14600.0
2007-04-02 18:30:00	SPY	ETF	142.23	142.23	142.23	142.23	100.0
2007-04-02 19:00:00	SPY	ETF	142.27	142.27	142.27	142.27	3900.0
2007-04-02 19:30:00	SPY	ETF	142.27	142.28	142.27	142.28	22300.0
2007-04-02 07:00:00	QQQ	ETF	43.64	43.64	43.64	43.64	5000.0
2007-04-02 07:30:00	QQQ	ETF	43.64	43.73	43.64	43.68	294050.0
2007-04-02 08:00:00	QQQ	ETF	43.68	43.72	43.54	43.67	186532.0
2007-04-02 08:30:00	QQQ	ETF	43.67	43.67	43.64	43.67	338747.0
2007-04-02 09:00:00	QQQ	ETF	43.67	43.69	43.53	43.66	407162.0
2007-04-02 09:30:00	QQQ	ETF	43.67	43.76	43.63	43.66	6727100.0
2007-04-02 10:00:00	QQQ	ETF	43.66	43.66	43.32	43.42	23953500.0
2007-04-02 10:30:00	QQQ	ETF	43.43	43.54	43.39	43.51	10510500.0
2007-04-02 11:00:00	QQQ	ETF	43.51	43.54	43.47	43.48	5805900.0
2007-04-02 11:30:00	QQQ	ETF	43.49	43.55	43.4	43.45	5292700.0
2007-04-02 12:00:00	QQQ	ETF	43.45	43.47	43.41	43.43	2483600.0
2007-04-02 12:30:00	QQQ	ETF	43.43	43.48	43.36	43.4	2838300.0
2007-04-02 13:00:00	QQQ	ETF	43.39	43.44	43.36	43.41	3230700.0
2007-04-02 13:30:00	QQQ	ETF	43.4	43.42	43.35	43.39	4147000.0
2007-04-02 14:00:00	QQQ	ETF	43.38	43.46	43.3	43.42	6359100.0
2007-04-02 14:30:00	QQQ	ETF	43.43	43.46	43.41	43.44	3231200.0
2007-04-02 15:00:00	QQQ	ETF	43.44	43.6	43.44	43.57	6307900.0
2007-04-02 15:30:00	QQQ	ETF	43.58	43.6	43.52	43.58	5196300.0
2007-04-02 16:00:00	QQQ	ETF	43.59	43.6	43.54	43.57	1895746.0
2007-04-02 16:30:00	QQQ	ETF	43.58	43.6	43.57	43.6	108028.0
2007-04-02 17:00:00	QQQ	ETF	43.59	43.62	43.59	43.61	29991.0

> showing 50 of 3,620 rows — these rows as CSV

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