PREVIEW / etf_30min / 2009-02-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-27.parquet
  size:    206 KB
  rows:    6,931

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-27 04:00:00	SPY	ETF	75.72	75.72	75.69	75.69	1800.0
2009-02-27 04:30:00	SPY	ETF	75.63	75.84	75.62	75.62	15300.0
2009-02-27 05:00:00	SPY	ETF	75.62	75.82	75.56	75.82	17100.0
2009-02-27 05:30:00	SPY	ETF	75.9	75.9	75.73	75.83	9868.0
2009-02-27 06:00:00	SPY	ETF	75.93	75.97	75.62	75.65	7700.0
2009-02-27 06:30:00	SPY	ETF	75.55	75.65	75.35	75.42	49000.0
2009-02-27 07:00:00	SPY	ETF	75.45	75.48	74.4	74.81	2089715.0
2009-02-27 07:30:00	SPY	ETF	74.86	74.96	74.54	74.77	1571237.0
2009-02-27 08:00:00	SPY	ETF	74.82	76.83	73.7	74.08	6027080.0
2009-02-27 08:30:00	SPY	ETF	74.06	74.13	73.53	74.06	9647764.0
2009-02-27 09:00:00	SPY	ETF	74.06	74.18	73.88	74.02	2246436.0
2009-02-27 09:30:00	SPY	ETF	74.01	74.69	73.81	74.46	45145839.0
2009-02-27 10:00:00	SPY	ETF	74.46	75.17	74.2	74.81	43664211.0
2009-02-27 10:30:00	SPY	ETF	74.81	75.16	74.54	74.85	27612071.0
2009-02-27 11:00:00	SPY	ETF	74.85	74.9	74.34	74.67	21987221.0
2009-02-27 11:30:00	SPY	ETF	74.67	75.3	74.49	75.1296	23152104.0
2009-02-27 12:00:00	SPY	ETF	75.1299	75.39	74.96	75.15	18039582.0
2009-02-27 12:30:00	SPY	ETF	75.15	75.27	74.71	75.1	13198751.0
2009-02-27 13:00:00	SPY	ETF	75.11	75.38	74.79	75.02	17031625.0
2009-02-27 13:30:00	SPY	ETF	75.03	75.39	74.41	75.28	31860931.0
2009-02-27 14:00:00	SPY	ETF	75.29	75.58	74.6512	74.73	25507387.0
2009-02-27 14:30:00	SPY	ETF	74.73	75.6872	74.5	75.06	33659746.0
2009-02-27 15:00:00	SPY	ETF	75.06	75.06	73.97	74.17	42387873.0
2009-02-27 15:30:00	SPY	ETF	74.17	74.8494	73.85	73.97	63305551.0
2009-02-27 16:00:00	SPY	ETF	73.97	75.6872	73.68	73.7	36637265.0
2009-02-27 16:30:00	SPY	ETF	73.72	75.6872	73.65	73.81	3970075.0
2009-02-27 17:00:00	SPY	ETF	73.78	73.79	73.69	73.73	86356.0
2009-02-27 17:30:00	SPY	ETF	73.73	74.245	73.71	73.78	93455.0
2009-02-27 18:00:00	SPY	ETF	73.78	73.88	73.78	73.88	31277.0
2009-02-27 18:30:00	SPY	ETF	73.84	73.89	73.78	73.81	4282.0
2009-02-27 19:00:00	SPY	ETF	73.81	73.87	73.76	73.77	20514.0
2009-02-27 19:30:00	SPY	ETF	73.79	73.88	73.78	73.85	18593.0
2009-02-27 04:00:00	QQQ	ETF	27.87	27.87	27.87	27.87	100.0
2009-02-27 04:30:00	QQQ	ETF	27.88	27.9	27.88	27.9	200.0
2009-02-27 05:00:00	QQQ	ETF	27.91	27.91	27.91	27.91	1000.0
2009-02-27 06:00:00	QQQ	ETF	27.93	27.93	27.93	27.93	100.0
2009-02-27 07:00:00	QQQ	ETF	27.77	27.79	27.55	27.61	43400.0
2009-02-27 07:30:00	QQQ	ETF	27.57	27.65	27.49	27.62	152701.0
2009-02-27 08:00:00	QQQ	ETF	27.8	27.97	27.37	27.41	1200613.0
2009-02-27 08:30:00	QQQ	ETF	27.37	27.46	27.3	27.42	1042631.0
2009-02-27 09:00:00	QQQ	ETF	27.43	27.51	27.39	27.49	1387895.0
2009-02-27 09:30:00	QQQ	ETF	27.49	27.86	27.39	27.7612	24167132.0
2009-02-27 10:00:00	QQQ	ETF	27.77	27.96	27.64	27.82	17264937.0
2009-02-27 10:30:00	QQQ	ETF	27.82	27.89	27.68	27.75	11564668.0
2009-02-27 11:00:00	QQQ	ETF	27.75	27.77	27.55	27.64	10721181.0
2009-02-27 11:30:00	QQQ	ETF	27.65	27.89	27.61	27.82	11672005.0
2009-02-27 12:00:00	QQQ	ETF	27.82	27.93	27.78	27.82	8667039.0
2009-02-27 12:30:00	QQQ	ETF	27.82	27.86	27.57	27.75	10255808.0
2009-02-27 13:00:00	QQQ	ETF	27.75	27.84	27.66	27.7699	7655942.0
2009-02-27 13:30:00	QQQ	ETF	27.77	27.89	27.59	27.87	10839435.0

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

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