PREVIEW / etf_30min / 2009-07-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-02.parquet
  size:    218 KB
  rows:    7,312

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-07-02 04:00:00	SPY	ETF	91.88	91.9	91.87	91.9	20418.0
2009-07-02 05:00:00	SPY	ETF	91.86	91.99	91.86	91.99	1200.0
2009-07-02 05:30:00	SPY	ETF	91.92	91.92	91.9	91.9	2000.0
2009-07-02 06:00:00	SPY	ETF	91.84	91.85	91.67	91.67	30200.0
2009-07-02 06:30:00	SPY	ETF	91.71	91.72	91.67	91.68	16400.0
2009-07-02 07:00:00	SPY	ETF	91.72	91.78	91.7	91.77	451914.0
2009-07-02 07:30:00	SPY	ETF	91.78	92.0	91.76	92.0	414231.0
2009-07-02 08:00:00	SPY	ETF	91.99	91.99	91.72	91.88	2012867.0
2009-07-02 08:30:00	SPY	ETF	91.86	91.86	90.96	91.14	13056726.0
2009-07-02 09:00:00	SPY	ETF	91.14	91.16	90.93	91.13	2247936.0
2009-07-02 09:30:00	SPY	ETF	91.13	91.16	90.34	90.48	29280317.0
2009-07-02 10:00:00	SPY	ETF	90.48	90.6591	90.18	90.3	19659672.0
2009-07-02 10:30:00	SPY	ETF	90.29	90.54	90.2	90.445	12778968.0
2009-07-02 11:00:00	SPY	ETF	90.43	90.52	90.3	90.33	9665081.0
2009-07-02 11:30:00	SPY	ETF	90.33	90.35	90.09	90.26	9399205.0
2009-07-02 12:00:00	SPY	ETF	90.26	90.36	90.21	90.26	6158950.0
2009-07-02 12:30:00	SPY	ETF	90.26	90.27	90.15	90.21	5192929.0
2009-07-02 13:00:00	SPY	ETF	90.21	90.36	90.2	90.24	6512474.0
2009-07-02 13:30:00	SPY	ETF	90.24	90.3	90.1	90.2001	6407978.0
2009-07-02 14:00:00	SPY	ETF	90.2	90.3	90.14	90.2	6669910.0
2009-07-02 14:30:00	SPY	ETF	90.19	90.3	90.115	90.22	6127804.0
2009-07-02 15:00:00	SPY	ETF	90.23	90.28	89.84	89.88	15433655.0
2009-07-02 15:30:00	SPY	ETF	89.88	90.15	89.76	89.82	26035477.0
2009-07-02 16:00:00	SPY	ETF	89.81	89.96	89.67	89.67	16118135.0
2009-07-02 16:30:00	SPY	ETF	89.69	92.3631	89.35	89.47	7664615.0
2009-07-02 17:00:00	SPY	ETF	89.47	91.11	89.47	89.58	561874.0
2009-07-02 17:30:00	SPY	ETF	89.56	89.58	89.38	89.39	426149.0
2009-07-02 18:00:00	SPY	ETF	89.42	89.55	89.39	89.55	562126.0
2009-07-02 18:30:00	SPY	ETF	89.54	89.59	89.52	89.59	42455.0
2009-07-02 19:00:00	SPY	ETF	89.59	89.62	89.57	89.59	68989.0
2009-07-02 19:30:00	SPY	ETF	89.6	89.7	89.6	89.63	44056.0
2009-07-02 04:00:00	QQQ	ETF	36.25	36.25	36.25	36.25	100.0
2009-07-02 05:00:00	QQQ	ETF	36.22	36.22	36.22	36.22	1000.0
2009-07-02 05:30:00	QQQ	ETF	36.22	36.22	36.22	36.22	364.0
2009-07-02 06:00:00	QQQ	ETF	36.2	36.2	36.2	36.2	250.0
2009-07-02 06:30:00	QQQ	ETF	36.2	36.2	36.2	36.2	2200.0
2009-07-02 07:00:00	QQQ	ETF	36.17	36.19	36.17	36.19	32709.0
2009-07-02 07:30:00	QQQ	ETF	36.2	36.28	36.2	36.28	78111.0
2009-07-02 08:00:00	QQQ	ETF	36.28	36.29	36.21	36.24	286721.0
2009-07-02 08:30:00	QQQ	ETF	36.23	36.37	36.06	36.13	4647856.0
2009-07-02 09:00:00	QQQ	ETF	36.13	36.14	36.05	36.09	686981.0
2009-07-02 09:30:00	QQQ	ETF	36.09	36.1	35.61	35.65	21387153.0
2009-07-02 10:00:00	QQQ	ETF	35.65	35.7263	35.5	35.5999	12503796.0
2009-07-02 10:30:00	QQQ	ETF	35.6	35.74	35.5388	35.69	8622668.0
2009-07-02 11:00:00	QQQ	ETF	35.68	35.71	35.6	35.62	4681264.0
2009-07-02 11:30:00	QQQ	ETF	35.62	35.68	35.53	35.629	5487868.0
2009-07-02 12:00:00	QQQ	ETF	35.62	35.67	35.59	35.6095	2450532.0
2009-07-02 12:30:00	QQQ	ETF	35.6	35.64	35.57	35.625	2142734.0
2009-07-02 13:00:00	QQQ	ETF	35.64	35.7	35.635	35.67	3479770.0
2009-07-02 13:30:00	QQQ	ETF	35.665	35.7	35.62	35.6499	2917450.0

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

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