PREVIEW / etf_30min / 2009-03-02

all etf 30-min files

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

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-03-02 04:00:00	SPY	ETF	72.5	72.7	72.39	72.45	2721.0
2009-03-02 04:30:00	SPY	ETF	72.57	72.8	72.57	72.8	1800.0
2009-03-02 05:00:00	SPY	ETF	72.78	72.78	72.47	72.53	900.0
2009-03-02 05:30:00	SPY	ETF	72.6	72.6	72.33	72.4	2200.0
2009-03-02 06:00:00	SPY	ETF	72.36	72.45	72.0	72.15	25100.0
2009-03-02 06:30:00	SPY	ETF	72.15	72.15	71.62	72.1	79000.0
2009-03-02 07:00:00	SPY	ETF	72.12	72.18	71.9	72.05	445151.0
2009-03-02 07:30:00	SPY	ETF	72.05	72.33	71.89	72.29	753855.0
2009-03-02 08:00:00	SPY	ETF	72.28	72.39	72.05	72.25	3258481.0
2009-03-02 08:30:00	SPY	ETF	72.29	73.4	72.04	72.36	6567737.0
2009-03-02 09:00:00	SPY	ETF	72.35	72.55	72.28	72.51	2382838.0
2009-03-02 09:30:00	SPY	ETF	72.52	72.92	72.19	72.55	38635536.0
2009-03-02 10:00:00	SPY	ETF	72.55	72.89	72.06	72.26	37374743.0
2009-03-02 10:30:00	SPY	ETF	72.26	72.36	71.86	71.97	23596981.0
2009-03-02 11:00:00	SPY	ETF	71.96	72.13	71.56	71.6	27966777.0
2009-03-02 11:30:00	SPY	ETF	71.59	71.65	71.06	71.24	26526550.0
2009-03-02 12:00:00	SPY	ETF	71.25	71.49	71.06	71.395	22012859.0
2009-03-02 12:30:00	SPY	ETF	71.38	71.52	70.97	71.03	30102142.0
2009-03-02 13:00:00	SPY	ETF	71.03	71.35	70.87	71.04	20179014.0
2009-03-02 13:30:00	SPY	ETF	71.04	71.44	70.81	71.43	17001505.0
2009-03-02 14:00:00	SPY	ETF	71.43	71.56	71.03	71.15	19127423.0
2009-03-02 14:30:00	SPY	ETF	71.1425	71.74	71.01	71.1114	30252495.0
2009-03-02 15:00:00	SPY	ETF	71.12	71.18	70.58	70.911	33602388.0
2009-03-02 15:30:00	SPY	ETF	70.92	71.75	70.37	70.58	58460939.0
2009-03-02 16:00:00	SPY	ETF	70.67	71.2	70.45	70.97	13961332.0
2009-03-02 16:30:00	SPY	ETF	71.0	73.9169	70.86	71.01	2580190.0
2009-03-02 17:00:00	SPY	ETF	71.02	71.08	70.96	71.01	430683.0
2009-03-02 17:30:00	SPY	ETF	71.01	73.93	70.95	70.96	58224.0
2009-03-02 18:00:00	SPY	ETF	70.97	71.1	70.93	71.05	99218.0
2009-03-02 18:30:00	SPY	ETF	71.05	71.15	71.05	71.1	21463.0
2009-03-02 19:00:00	SPY	ETF	71.1	71.34	71.1	71.2	77087.0
2009-03-02 19:30:00	SPY	ETF	71.26	71.27	71.19	71.23	28559.0
2009-03-02 04:00:00	QQQ	ETF	27.11	27.17	27.09	27.09	1100.0
2009-03-02 04:30:00	QQQ	ETF	27.15	27.16	27.15	27.16	650.0
2009-03-02 05:30:00	QQQ	ETF	27.03	27.04	27.02	27.04	2346.0
2009-03-02 06:00:00	QQQ	ETF	26.96	26.97	26.83	26.84	10400.0
2009-03-02 06:30:00	QQQ	ETF	26.84	26.84	26.71	26.71	6152.0
2009-03-02 07:00:00	QQQ	ETF	26.87	26.96	26.86	26.93	291459.0
2009-03-02 07:30:00	QQQ	ETF	26.93	27.04	26.84	27.03	622060.0
2009-03-02 08:00:00	QQQ	ETF	27.03	27.07	26.87	26.97	1099117.0
2009-03-02 08:30:00	QQQ	ETF	26.96	27.15	26.76	27.07	1470074.0
2009-03-02 09:00:00	QQQ	ETF	27.06	27.14	27.05	27.11	622098.0
2009-03-02 09:30:00	QQQ	ETF	27.11	27.51	27.05	27.32	31043001.0
2009-03-02 10:00:00	QQQ	ETF	27.3213	27.47	27.08	27.18	13493576.0
2009-03-02 10:30:00	QQQ	ETF	27.18	27.22	26.98	27.03	9238282.0
2009-03-02 11:00:00	QQQ	ETF	27.02	27.11	26.95	26.96	8614684.0
2009-03-02 11:30:00	QQQ	ETF	26.96	27.0	26.73	26.81	7799485.0
2009-03-02 12:00:00	QQQ	ETF	26.81	26.91	26.76	26.88	9360248.0
2009-03-02 12:30:00	QQQ	ETF	26.87	26.94	26.65	26.68	8392333.0
2009-03-02 13:00:00	QQQ	ETF	26.67	26.78	26.58	26.642	8050576.0

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

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