PREVIEW / etf_30min / 2009-03-31

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-31.parquet
  size:    209 KB
  rows:    6,924

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-31 04:00:00	SPY	ETF	79.61	79.61	79.5	79.6	10734.0
2009-03-31 04:30:00	SPY	ETF	79.59	79.59	79.51	79.58	3100.0
2009-03-31 05:00:00	SPY	ETF	79.52	79.52	79.46	79.46	301.0
2009-03-31 05:30:00	SPY	ETF	79.56	79.64	79.56	79.56	4400.0
2009-03-31 06:00:00	SPY	ETF	79.28	79.64	79.22	79.64	33200.0
2009-03-31 06:30:00	SPY	ETF	79.65	79.73	79.53	79.72	105075.0
2009-03-31 07:00:00	SPY	ETF	79.65	79.69	79.45	79.45	556900.0
2009-03-31 07:30:00	SPY	ETF	79.46	79.57	79.45	79.54	333502.0
2009-03-31 08:00:00	SPY	ETF	79.53	79.74	79.1468	79.63	1868974.0
2009-03-31 08:30:00	SPY	ETF	79.62	79.76	79.58	79.65	766374.0
2009-03-31 09:00:00	SPY	ETF	79.65	79.71	79.47	79.54	1545767.0
2009-03-31 09:30:00	SPY	ETF	79.56	79.74	79.09	79.24	29070091.0
2009-03-31 10:00:00	SPY	ETF	79.23	79.61	79.05	79.59	31956519.0
2009-03-31 10:30:00	SPY	ETF	79.6	79.92	79.45	79.58	22878609.0
2009-03-31 11:00:00	SPY	ETF	79.58	80.01	79.57	79.91	24381033.0
2009-03-31 11:30:00	SPY	ETF	79.91	80.03	79.66	79.89	13202843.0
2009-03-31 12:00:00	SPY	ETF	79.8801	79.9	79.55	79.62	11094489.0
2009-03-31 12:30:00	SPY	ETF	79.62	79.98	79.55	79.95	9189849.0
2009-03-31 13:00:00	SPY	ETF	79.96	80.32	79.92	80.21	16036875.0
2009-03-31 13:30:00	SPY	ETF	80.21	80.43	80.15	80.4	15306297.0
2009-03-31 14:00:00	SPY	ETF	80.4	80.69	80.31	80.54	19919068.0
2009-03-31 14:30:00	SPY	ETF	80.55	81.08	79.15	80.81	24800638.0
2009-03-31 15:00:00	SPY	ETF	80.81	80.85	80.5	80.82	25153502.0
2009-03-31 15:30:00	SPY	ETF	80.82	80.84	79.44	79.5	82389414.0
2009-03-31 16:00:00	SPY	ETF	79.55	80.26	79.36	79.51	25915995.0
2009-03-31 16:30:00	SPY	ETF	79.48	80.17	79.25	79.32	2425587.0
2009-03-31 17:00:00	SPY	ETF	79.28	79.32	78.7586	79.1	1895383.0
2009-03-31 17:30:00	SPY	ETF	79.12	79.14	79.0	79.12	1308621.0
2009-03-31 18:00:00	SPY	ETF	79.12	79.13	78.99	79.05	221986.0
2009-03-31 18:30:00	SPY	ETF	79.04	79.07	78.96	78.99	98350.0
2009-03-31 19:00:00	SPY	ETF	78.97	79.25	78.95	79.24	111247.0
2009-03-31 19:30:00	SPY	ETF	79.24	79.25	79.0	79.02	20075.0
2009-03-31 04:00:00	QQQ	ETF	30.46	30.47	30.44	30.44	5300.0
2009-03-31 04:30:00	QQQ	ETF	30.5	30.5	30.42	30.42	1750.0
2009-03-31 05:00:00	QQQ	ETF	30.4	30.41	30.4	30.41	1100.0
2009-03-31 05:30:00	QQQ	ETF	30.4	30.4	30.4	30.4	200.0
2009-03-31 06:00:00	QQQ	ETF	30.3	30.3	30.3	30.3	1100.0
2009-03-31 06:30:00	QQQ	ETF	30.41	30.43	30.41	30.42	1600.0
2009-03-31 07:00:00	QQQ	ETF	30.44	30.47	30.37	30.37	97527.0
2009-03-31 07:30:00	QQQ	ETF	30.36	30.38	30.33	30.37	152731.0
2009-03-31 08:00:00	QQQ	ETF	30.37	30.51	30.2	30.35	601638.0
2009-03-31 08:30:00	QQQ	ETF	30.35	30.44	30.35	30.43	645476.0
2009-03-31 09:00:00	QQQ	ETF	30.42	30.42	30.31	30.31	300980.0
2009-03-31 09:30:00	QQQ	ETF	30.31	30.48	30.27	30.35	13774573.0
2009-03-31 10:00:00	QQQ	ETF	30.34	30.5	30.3	30.45	10615101.0
2009-03-31 10:30:00	QQQ	ETF	30.45	30.56	30.32	30.37	8933124.0
2009-03-31 11:00:00	QQQ	ETF	30.37	30.5	30.37	30.4701	6894030.0
2009-03-31 11:30:00	QQQ	ETF	30.48	30.54	30.4	30.47	4995050.0
2009-03-31 12:00:00	QQQ	ETF	30.46	30.47	30.35	30.38	6537189.0
2009-03-31 12:30:00	QQQ	ETF	30.38	30.58	30.36	30.55	5906176.0

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

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