PREVIEW / etf_30min / 2009-04-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-02.parquet
  size:    223 KB
  rows:    7,403

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-04-02 04:00:00	SPY	ETF	82.91	82.97	82.86	82.88	3800.0
2009-04-02 04:30:00	SPY	ETF	82.8	82.8	82.75	82.77	400.0
2009-04-02 05:00:00	SPY	ETF	82.85	83.15	82.85	83.15	3752.0
2009-04-02 05:30:00	SPY	ETF	83.18	83.2	83.08	83.2	3350.0
2009-04-02 06:00:00	SPY	ETF	83.24	83.31	83.09	83.1	50746.0
2009-04-02 06:30:00	SPY	ETF	83.1	83.15	82.92	82.99	199600.0
2009-04-02 07:00:00	SPY	ETF	82.94	83.07	82.73	82.91	306015.0
2009-04-02 07:30:00	SPY	ETF	82.92	82.94	82.43	82.85	1303786.0
2009-04-02 08:00:00	SPY	ETF	82.83	83.12	82.49	82.85	2335084.0
2009-04-02 08:30:00	SPY	ETF	82.83	83.09	82.48	82.7	6574372.0
2009-04-02 09:00:00	SPY	ETF	82.7	83.11	82.67	83.09	4029184.0
2009-04-02 09:30:00	SPY	ETF	83.08	83.39	82.73	83.37	45374650.0
2009-04-02 10:00:00	SPY	ETF	83.37	83.67	83.02	83.0799	38899240.0
2009-04-02 10:30:00	SPY	ETF	83.045	83.71	83.01	83.66	36423472.0
2009-04-02 11:00:00	SPY	ETF	83.66	84.25	83.618	84.15	35313085.0
2009-04-02 11:30:00	SPY	ETF	84.15	84.16	83.83	84.03	22428708.0
2009-04-02 12:00:00	SPY	ETF	84.03	84.58	83.87	84.45	24035173.0
2009-04-02 12:30:00	SPY	ETF	84.45	84.61	84.17	84.17	22173513.0
2009-04-02 13:00:00	SPY	ETF	84.18	84.25	83.74	83.85	24439863.0
2009-04-02 13:30:00	SPY	ETF	83.86	84.02	83.51	83.68	25726942.0
2009-04-02 14:00:00	SPY	ETF	83.68	84.1	83.58	84.06	20868340.0
2009-04-02 14:30:00	SPY	ETF	84.0506	84.46	83.93	84.03	26043039.0
2009-04-02 15:00:00	SPY	ETF	84.03	84.24	83.6	83.91	27382397.0
2009-04-02 15:30:00	SPY	ETF	83.9	84.09	83.02	83.41	65173815.0
2009-04-02 16:00:00	SPY	ETF	83.43	84.09	82.84	83.94	25767411.0
2009-04-02 16:30:00	SPY	ETF	83.93	84.09	83.39	83.95	6820643.0
2009-04-02 17:00:00	SPY	ETF	83.98	84.07	83.93	84.07	169703.0
2009-04-02 17:30:00	SPY	ETF	84.0	84.01	83.96	84.0	61934.0
2009-04-02 18:00:00	SPY	ETF	84.02	84.02	83.84	83.84	115977.0
2009-04-02 18:30:00	SPY	ETF	83.85	83.95	83.85	83.89	32823.0
2009-04-02 19:00:00	SPY	ETF	83.89	83.91	83.83	83.85	17342.0
2009-04-02 19:30:00	SPY	ETF	83.86	83.97	83.83	83.92	28396.0
2009-04-02 04:00:00	QQQ	ETF	31.35	31.35	31.35	31.35	600.0
2009-04-02 04:30:00	QQQ	ETF	31.3	31.3	31.3	31.3	301.0
2009-04-02 05:00:00	QQQ	ETF	31.4	31.5	31.4	31.5	41600.0
2009-04-02 05:30:00	QQQ	ETF	31.5	31.53	31.45	31.52	2500.0
2009-04-02 06:00:00	QQQ	ETF	31.56	31.6	31.54	31.54	2000.0
2009-04-02 06:30:00	QQQ	ETF	31.52	31.52	31.43	31.45	350742.0
2009-04-02 07:00:00	QQQ	ETF	31.42	31.5	31.38	31.44	487571.0
2009-04-02 07:30:00	QQQ	ETF	31.44	31.44	31.32	31.37	308903.0
2009-04-02 08:00:00	QQQ	ETF	31.36	31.46	31.19	31.34	1388928.0
2009-04-02 08:30:00	QQQ	ETF	31.34	31.44	31.23	31.3	1851205.0
2009-04-02 09:00:00	QQQ	ETF	31.29	31.37	31.27	31.33	2262003.0
2009-04-02 09:30:00	QQQ	ETF	31.34	31.6	31.23	31.6	25004383.0
2009-04-02 10:00:00	QQQ	ETF	31.6	31.72	31.54	31.57	17568791.0
2009-04-02 10:30:00	QQQ	ETF	31.57	31.89	31.56	31.87	17150540.0
2009-04-02 11:00:00	QQQ	ETF	31.87	32.11	31.86	32.0786	12963227.0
2009-04-02 11:30:00	QQQ	ETF	32.08	32.08	31.97	32.0301	8135737.0
2009-04-02 12:00:00	QQQ	ETF	32.04	32.27	31.98	32.2301	10629494.0
2009-04-02 12:30:00	QQQ	ETF	32.24	32.26	31.68	32.1	7433046.0

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

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