PREVIEW / etf_30min / 2009-04-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-21.parquet
  size:    219 KB
  rows:    7,266

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-21 04:00:00	SPY	ETF	84.06	84.16	84.06	84.14	10500.0
2009-04-21 04:30:00	SPY	ETF	84.16	84.24	84.02	84.02	86200.0
2009-04-21 05:00:00	SPY	ETF	84.13	84.22	84.03	84.06	17549.0
2009-04-21 05:30:00	SPY	ETF	83.95	84.06	83.83	83.83	11200.0
2009-04-21 06:00:00	SPY	ETF	83.8	84.13	83.8	83.85	53600.0
2009-04-21 06:30:00	SPY	ETF	83.85	83.86	83.19	83.32	77977.0
2009-04-21 07:00:00	SPY	ETF	83.31	83.39	83.11	83.12	820775.0
2009-04-21 07:30:00	SPY	ETF	83.14	83.35	83.06	83.18	930314.0
2009-04-21 08:00:00	SPY	ETF	83.18	84.14	82.84	82.92	2312738.0
2009-04-21 08:30:00	SPY	ETF	82.92	83.14	82.89	82.93	2028152.0
2009-04-21 09:00:00	SPY	ETF	82.93	82.96	82.75	82.83	2280049.0
2009-04-21 09:30:00	SPY	ETF	82.82	83.6	82.75	83.41	37355213.0
2009-04-21 10:00:00	SPY	ETF	83.42	83.48	82.98	83.0501	19610000.0
2009-04-21 10:30:00	SPY	ETF	83.06	83.5	82.9	83.5	17736101.0
2009-04-21 11:00:00	SPY	ETF	83.5	84.15	83.49	83.99	27468184.0
2009-04-21 11:30:00	SPY	ETF	83.99	84.37	83.93	84.27	19806486.0
2009-04-21 12:00:00	SPY	ETF	84.2699	84.47	84.2	84.32	12036088.0
2009-04-21 12:30:00	SPY	ETF	84.31	84.64	84.3	84.36	13764798.0
2009-04-21 13:00:00	SPY	ETF	84.3699	84.56	83.2	84.305	12876676.0
2009-04-21 13:30:00	SPY	ETF	84.3	84.55	84.16	84.38	13070984.0
2009-04-21 14:00:00	SPY	ETF	84.38	84.51	84.03	84.36	14393343.0
2009-04-21 14:30:00	SPY	ETF	84.36	84.7	84.34	84.39	16684040.0
2009-04-21 15:00:00	SPY	ETF	84.39	85.13	84.3	84.79	24678810.0
2009-04-21 15:30:00	SPY	ETF	84.781	85.1	84.47	85.06	38482742.0
2009-04-21 16:00:00	SPY	ETF	85.06	85.31	83.1297	85.23	12576035.0
2009-04-21 16:30:00	SPY	ETF	85.23	85.3	83.3322	85.07	4548516.0
2009-04-21 17:00:00	SPY	ETF	85.08	85.28	84.8	84.99	5142407.0
2009-04-21 17:30:00	SPY	ETF	84.98	84.98	84.88	84.95	97108.0
2009-04-21 18:00:00	SPY	ETF	84.97	85.09	84.96	85.07	81066.0
2009-04-21 18:30:00	SPY	ETF	85.06	85.11	84.95	84.95	30560.0
2009-04-21 19:00:00	SPY	ETF	84.98	84.99	84.91	84.99	14051.0
2009-04-21 19:30:00	SPY	ETF	84.95	84.97	84.91	84.93	29412.0
2009-04-21 04:00:00	QQQ	ETF	32.45	32.45	32.45	32.45	690.0
2009-04-21 04:30:00	QQQ	ETF	32.49	32.49	32.45	32.45	200.0
2009-04-21 05:00:00	QQQ	ETF	32.44	32.44	32.44	32.44	100.0
2009-04-21 06:00:00	QQQ	ETF	32.43	32.43	32.38	32.38	1800.0
2009-04-21 06:30:00	QQQ	ETF	32.4	32.4	32.32	32.32	1600.0
2009-04-21 07:00:00	QQQ	ETF	32.21	32.28	32.18	32.18	38026.0
2009-04-21 07:30:00	QQQ	ETF	32.18	32.24	32.16	32.2	39701.0
2009-04-21 08:00:00	QQQ	ETF	32.22	32.22	32.1	32.12	611919.0
2009-04-21 08:30:00	QQQ	ETF	32.12	32.18	32.12	32.13	563975.0
2009-04-21 09:00:00	QQQ	ETF	32.13	32.13	32.01	32.07	992422.0
2009-04-21 09:30:00	QQQ	ETF	32.08	32.66	32.08	32.55	24519731.0
2009-04-21 10:00:00	QQQ	ETF	32.55	32.57	32.28	32.3289	9183350.0
2009-04-21 10:30:00	QQQ	ETF	32.32	32.41	32.24	32.4	8614203.0
2009-04-21 11:00:00	QQQ	ETF	32.4	32.64	32.39	32.53	12126399.0
2009-04-21 11:30:00	QQQ	ETF	32.53	32.63	32.48	32.56	7789945.0
2009-04-21 12:00:00	QQQ	ETF	32.569	32.66	32.55	32.57	5869192.0
2009-04-21 12:30:00	QQQ	ETF	32.57	32.66	32.54	32.56	4642623.0
2009-04-21 13:00:00	QQQ	ETF	32.56	32.59	32.47	32.502	4389971.0

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

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