PREVIEW / etf_30min / 2009-02-19

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-19.parquet
  size:    207 KB
  rows:    6,770

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-19 04:00:00	SPY	ETF	79.16	79.33	79.16	79.31	950.0
2009-02-19 04:30:00	SPY	ETF	79.44	79.44	79.39	79.39	1900.0
2009-02-19 05:00:00	SPY	ETF	79.29	79.35	79.29	79.32	1633.0
2009-02-19 05:30:00	SPY	ETF	79.35	79.48	79.31	79.31	3874.0
2009-02-19 06:00:00	SPY	ETF	79.2	79.25	79.19	79.19	5800.0
2009-02-19 06:30:00	SPY	ETF	79.16	79.3	79.16	79.18	36400.0
2009-02-19 07:00:00	SPY	ETF	79.2	79.34	79.15	79.34	578483.0
2009-02-19 07:30:00	SPY	ETF	79.33	79.69	79.24	79.65	1069091.0
2009-02-19 08:00:00	SPY	ETF	79.4	79.68	78.56	79.52	1875853.0
2009-02-19 08:30:00	SPY	ETF	79.55	79.89	79.15	79.7	2958049.0
2009-02-19 09:00:00	SPY	ETF	79.7	80.1	79.65	79.85	2693873.0
2009-02-19 09:30:00	SPY	ETF	79.84	80.15	79.7	80.02	34169525.0
2009-02-19 10:00:00	SPY	ETF	80.02	80.05	79.1858	79.52	29991998.0
2009-02-19 10:30:00	SPY	ETF	79.53	79.94	79.18	79.23	17618639.0
2009-02-19 11:00:00	SPY	ETF	79.22	79.84	79.13	79.44	18958145.0
2009-02-19 11:30:00	SPY	ETF	79.44	79.49	78.79	78.85	17698997.0
2009-02-19 12:00:00	SPY	ETF	78.86	78.95	78.51	78.72	19967073.0
2009-02-19 12:30:00	SPY	ETF	78.72	79.0	78.62	78.88	9397068.0
2009-02-19 13:00:00	SPY	ETF	78.88	79.46	78.72	79.39	16483975.0
2009-02-19 13:30:00	SPY	ETF	79.4	79.41	78.82	78.94	13382576.0
2009-02-19 14:00:00	SPY	ETF	78.94	79.21	78.66	78.8901	17715313.0
2009-02-19 14:30:00	SPY	ETF	78.9	78.96	78.47	78.76	18118968.0
2009-02-19 15:00:00	SPY	ETF	78.75	78.94	78.19	78.62	24925040.0
2009-02-19 15:30:00	SPY	ETF	78.62	79.3	78.02	78.28	44857100.0
2009-02-19 16:00:00	SPY	ETF	78.27	79.1858	77.96	78.33	22097149.0
2009-02-19 16:30:00	SPY	ETF	78.33	78.4	78.16	78.21	540656.0
2009-02-19 17:00:00	SPY	ETF	78.23	78.32	78.2	78.32	152830.0
2009-02-19 17:30:00	SPY	ETF	78.35	78.35	78.22	78.26	58670.0
2009-02-19 18:00:00	SPY	ETF	78.26	79.1858	78.14	78.37	1047645.0
2009-02-19 18:30:00	SPY	ETF	78.25	78.3	78.23	78.27	2700.0
2009-02-19 19:00:00	SPY	ETF	78.35	78.37	78.2	78.25	8694.0
2009-02-19 19:30:00	SPY	ETF	78.21	78.21	78.04	78.07	36509.0
2009-02-19 04:00:00	QQQ	ETF	29.27	29.27	29.27	29.27	675.0
2009-02-19 05:30:00	QQQ	ETF	29.31	29.31	29.31	29.31	100.0
2009-02-19 06:00:00	QQQ	ETF	29.23	29.27	29.23	29.25	25100.0
2009-02-19 06:30:00	QQQ	ETF	29.29	29.29	29.25	29.25	1175.0
2009-02-19 07:00:00	QQQ	ETF	29.25	29.31	29.23	29.26	498909.0
2009-02-19 07:30:00	QQQ	ETF	29.27	29.4	29.24	29.4	220451.0
2009-02-19 08:00:00	QQQ	ETF	29.29	29.39	29.29	29.36	840536.0
2009-02-19 08:30:00	QQQ	ETF	29.34	29.46	29.24	29.44	3056253.0
2009-02-19 09:00:00	QQQ	ETF	29.43	29.57	29.39	29.43	2616799.0
2009-02-19 09:30:00	QQQ	ETF	29.43	29.61	29.3701	29.52	19219554.0
2009-02-19 10:00:00	QQQ	ETF	29.51	29.55	29.13	29.23	15856450.0
2009-02-19 10:30:00	QQQ	ETF	29.23	29.24	29.05	29.08	12639108.0
2009-02-19 11:00:00	QQQ	ETF	29.08	29.25	29.05	29.16	8261292.0
2009-02-19 11:30:00	QQQ	ETF	29.17	29.17	28.9301	28.9711	8934784.0
2009-02-19 12:00:00	QQQ	ETF	28.9799	28.99	28.83	28.91	8424097.0
2009-02-19 12:30:00	QQQ	ETF	28.91	29.07	28.89	29.0	4082456.0
2009-02-19 13:00:00	QQQ	ETF	29.01	29.19	28.93	29.17	6365280.0
2009-02-19 13:30:00	QQQ	ETF	29.17	29.17	28.98	29.0099	4357857.0

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

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