PREVIEW / etf_30min / 2009-02-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-18.parquet
  size:    203 KB
  rows:    6,824

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-18 04:00:00	SPY	ETF	79.47	79.47	79.25	79.4	3800.0
2009-02-18 04:30:00	SPY	ETF	79.35	79.35	79.2	79.3	1200.0
2009-02-18 05:00:00	SPY	ETF	79.3	79.32	79.01	79.31	5000.0
2009-02-18 05:30:00	SPY	ETF	79.35	79.36	79.34	79.36	1900.0
2009-02-18 06:00:00	SPY	ETF	79.32	79.37	79.29	79.37	5300.0
2009-02-18 06:30:00	SPY	ETF	79.45	79.7	79.45	79.63	20800.0
2009-02-18 07:00:00	SPY	ETF	79.57	79.59	79.39	79.5	211864.0
2009-02-18 07:30:00	SPY	ETF	79.5	79.5	79.36	79.38	130018.0
2009-02-18 08:00:00	SPY	ETF	79.57	79.63	79.3	79.56	1051706.0
2009-02-18 08:30:00	SPY	ETF	79.52	79.79	79.38	79.78	1850904.0
2009-02-18 09:00:00	SPY	ETF	79.78	80.1	79.67	79.8	4359410.0
2009-02-18 09:30:00	SPY	ETF	79.79	79.82	79.0	79.04	34000675.0
2009-02-18 10:00:00	SPY	ETF	79.04	79.45	78.28	78.76	40930944.0
2009-02-18 10:30:00	SPY	ETF	78.77	79.28	78.73	78.85	31603965.0
2009-02-18 11:00:00	SPY	ETF	78.85	79.68	78.65	79.51	27655373.0
2009-02-18 11:30:00	SPY	ETF	79.515	79.78	79.35	79.5	18540069.0
2009-02-18 12:00:00	SPY	ETF	79.5	79.94	79.38	79.48	19609238.0
2009-02-18 12:30:00	SPY	ETF	79.49	79.62	79.04	79.45	16936979.0
2009-02-18 13:00:00	SPY	ETF	79.43	79.67	78.9	79.14	19599408.0
2009-02-18 13:30:00	SPY	ETF	79.14	79.16	78.7	78.87	16432001.0
2009-02-18 14:00:00	SPY	ETF	78.87	79.2	78.54	78.98	24689601.0
2009-02-18 14:30:00	SPY	ETF	78.99	79.29	78.57	79.26	22070058.0
2009-02-18 15:00:00	SPY	ETF	79.25	79.44	78.87	78.97	31932078.0
2009-02-18 15:30:00	SPY	ETF	78.96	79.31	78.87	79.06	31201180.0
2009-02-18 16:00:00	SPY	ETF	79.01	79.269	78.17	78.56	10646669.0
2009-02-18 16:30:00	SPY	ETF	78.51	79.75	78.28	78.29	2408047.0
2009-02-18 17:00:00	SPY	ETF	78.27	78.36	78.17	78.31	932612.0
2009-02-18 17:30:00	SPY	ETF	78.32	78.34	78.12	78.18	142496.0
2009-02-18 18:00:00	SPY	ETF	78.26	78.33	78.2	78.33	223451.0
2009-02-18 18:30:00	SPY	ETF	78.31	78.55	78.31	78.54	89813.0
2009-02-18 19:00:00	SPY	ETF	78.53	78.61	78.44	78.61	68544.0
2009-02-18 19:30:00	SPY	ETF	78.62	78.62	78.47	78.53	91101.0
2009-02-18 04:00:00	QQQ	ETF	29.24	29.24	29.16	29.21	8100.0
2009-02-18 06:30:00	QQQ	ETF	29.29	29.32	29.27	29.32	10300.0
2009-02-18 07:00:00	QQQ	ETF	29.3	29.3	29.21	29.27	50286.0
2009-02-18 07:30:00	QQQ	ETF	29.24	29.25	29.22	29.25	54139.0
2009-02-18 08:00:00	QQQ	ETF	29.24	29.32	29.22	29.32	122410.0
2009-02-18 08:30:00	QQQ	ETF	29.32	29.46	29.3	29.45	429345.0
2009-02-18 09:00:00	QQQ	ETF	29.43	29.54	29.39	29.42	929716.0
2009-02-18 09:30:00	QQQ	ETF	29.41	29.47	29.16	29.19	12587546.0
2009-02-18 10:00:00	QQQ	ETF	29.19	29.34	28.87	29.1701	17239937.0
2009-02-18 10:30:00	QQQ	ETF	29.17	29.36	29.17	29.24	12325515.0
2009-02-18 11:00:00	QQQ	ETF	29.25	29.59	29.19	29.55	10221020.0
2009-02-18 11:30:00	QQQ	ETF	29.55	29.62	29.44	29.5	9937304.0
2009-02-18 12:00:00	QQQ	ETF	29.49	29.6699	29.41	29.46	9690472.0
2009-02-18 12:30:00	QQQ	ETF	29.46	29.53	29.38	29.4801	7064634.0
2009-02-18 13:00:00	QQQ	ETF	29.48	29.55	29.27	29.35	8437054.0
2009-02-18 13:30:00	QQQ	ETF	29.35	29.37	29.17	29.21	9644017.0
2009-02-18 14:00:00	QQQ	ETF	29.22	29.34	29.1	29.27	10077377.0
2009-02-18 14:30:00	QQQ	ETF	29.28	29.4	29.15	29.3999	9418694.0

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

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