PREVIEW / etf_30min / 2009-02-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-05.parquet
  size:    201 KB
  rows:    6,607

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-05 04:00:00	SPY	ETF	83.11	83.16	83.11	83.16	2400.0
2009-02-05 04:30:00	SPY	ETF	83.23	83.26	83.14	83.14	500.0
2009-02-05 06:00:00	SPY	ETF	83.21	83.3	83.21	83.28	7200.0
2009-02-05 06:30:00	SPY	ETF	83.25	83.4	83.17	83.27	144800.0
2009-02-05 07:00:00	SPY	ETF	83.27	83.35	83.04	83.07	169200.0
2009-02-05 07:30:00	SPY	ETF	83.07	83.07	82.69	82.89	391644.0
2009-02-05 08:00:00	SPY	ETF	82.87	83.47	82.76	83.15	1201544.0
2009-02-05 08:30:00	SPY	ETF	83.16	83.25	82.5	82.71	3572866.0
2009-02-05 09:00:00	SPY	ETF	82.72	82.81	82.56	82.7	2003379.0
2009-02-05 09:30:00	SPY	ETF	82.7	82.97	82.13	82.19	26563832.0
2009-02-05 10:00:00	SPY	ETF	82.19	82.75	82.12	82.49	21865449.0
2009-02-05 10:30:00	SPY	ETF	82.49	84.08	82.36	83.79	33970668.0
2009-02-05 11:00:00	SPY	ETF	83.79	84.2	83.69	83.85	28135006.0
2009-02-05 11:30:00	SPY	ETF	83.85	84.41	83.82	84.39	22545741.0
2009-02-05 12:00:00	SPY	ETF	84.39	85.18	84.39	84.55	32855772.0
2009-02-05 12:30:00	SPY	ETF	84.55	84.86	84.35	84.77	24470822.0
2009-02-05 13:00:00	SPY	ETF	84.78	85.06	84.3	84.37	21978525.0
2009-02-05 13:30:00	SPY	ETF	84.37	84.82	84.34	84.46	23193529.0
2009-02-05 14:00:00	SPY	ETF	84.45	85.21	84.4475	85.2	23608250.0
2009-02-05 14:30:00	SPY	ETF	85.2	85.29	84.38	84.49	31931447.0
2009-02-05 15:00:00	SPY	ETF	84.49	84.96	84.11	84.88	34668452.0
2009-02-05 15:30:00	SPY	ETF	84.88	84.99	84.56	84.66	37069629.0
2009-02-05 16:00:00	SPY	ETF	84.61	84.72	81.7	84.46	20041028.0
2009-02-05 16:30:00	SPY	ETF	84.48	84.59	84.39	84.57	2929081.0
2009-02-05 17:00:00	SPY	ETF	84.57	84.59	84.37	84.46	9147001.0
2009-02-05 17:30:00	SPY	ETF	84.48	84.5	84.46	84.5	30209.0
2009-02-05 18:00:00	SPY	ETF	84.5	84.52	84.38	84.38	61160.0
2009-02-05 18:30:00	SPY	ETF	84.4	84.52	84.38	84.51	21945.0
2009-02-05 19:00:00	SPY	ETF	84.53	84.71	84.4	84.41	65903.0
2009-02-05 19:30:00	SPY	ETF	84.46	84.59	84.44	84.49	36025.0
2009-02-05 05:00:00	QQQ	ETF	29.5	29.51	29.5	29.51	700.0
2009-02-05 05:30:00	QQQ	ETF	29.51	29.51	29.51	29.51	111.0
2009-02-05 06:00:00	QQQ	ETF	29.5	29.5	29.5	29.5	1000.0
2009-02-05 06:30:00	QQQ	ETF	29.5	29.56	29.49	29.52	2800.0
2009-02-05 07:00:00	QQQ	ETF	29.53	29.55	29.48	29.5	131693.0
2009-02-05 07:30:00	QQQ	ETF	29.49	29.5	29.37	29.49	199471.0
2009-02-05 08:00:00	QQQ	ETF	29.49	29.56	29.43	29.53	463657.0
2009-02-05 08:30:00	QQQ	ETF	29.56	29.59	29.36	29.46	966020.0
2009-02-05 09:00:00	QQQ	ETF	29.46	29.49	29.41	29.48	887123.0
2009-02-05 09:30:00	QQQ	ETF	29.47	29.77	29.46	29.59	21640288.0
2009-02-05 10:00:00	QQQ	ETF	29.59	29.97	29.56	29.86	16181771.0
2009-02-05 10:30:00	QQQ	ETF	29.86	30.42	29.83	30.282	20292966.0
2009-02-05 11:00:00	QQQ	ETF	30.29	30.4	30.19	30.2683	14672636.0
2009-02-05 11:30:00	QQQ	ETF	30.27	30.48	30.26	30.47	17030499.0
2009-02-05 12:00:00	QQQ	ETF	30.4717	30.75	30.4717	30.5	18738064.0
2009-02-05 12:30:00	QQQ	ETF	30.49	30.54	30.36	30.51	15951231.0
2009-02-05 13:00:00	QQQ	ETF	30.52	30.59	30.4	30.4279	9758858.0
2009-02-05 13:30:00	QQQ	ETF	30.43	30.55	30.4	30.4405	6638864.0
2009-02-05 14:00:00	QQQ	ETF	30.449	30.71	30.44	30.71	11439352.0
2009-02-05 14:30:00	QQQ	ETF	30.71	30.77	30.47	30.5001	14614120.0

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

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