PREVIEW / etf_30min / 2009-01-08

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-08.parquet
  size:    200 KB
  rows:    6,585

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-01-08 04:00:00	SPY	ETF	90.85	90.94	90.85	90.94	1800.0
2009-01-08 04:30:00	SPY	ETF	90.89	90.91	90.68	90.68	11200.0
2009-01-08 05:00:00	SPY	ETF	90.58	90.58	90.2	90.2	2560.0
2009-01-08 05:30:00	SPY	ETF	90.2	90.32	90.2	90.32	700.0
2009-01-08 06:00:00	SPY	ETF	90.38	90.6	90.37	90.6	5600.0
2009-01-08 06:30:00	SPY	ETF	90.74	90.74	90.66	90.66	8767.0
2009-01-08 07:00:00	SPY	ETF	90.67	90.93	90.52	90.58	363537.0
2009-01-08 07:30:00	SPY	ETF	90.57	90.57	89.73	89.82	1285744.0
2009-01-08 08:00:00	SPY	ETF	89.83	90.77	89.52	89.65	2440975.0
2009-01-08 08:30:00	SPY	ETF	89.65	90.15	89.65	90.06	2264873.0
2009-01-08 09:00:00	SPY	ETF	90.05	90.26	90.0	90.16	875159.0
2009-01-08 09:30:00	SPY	ETF	90.16	90.39	89.7	89.89	25057155.0
2009-01-08 10:00:00	SPY	ETF	89.89	90.17	89.67	90.11	19545445.0
2009-01-08 10:30:00	SPY	ETF	90.1	90.68	89.92	90.5	23020893.0
2009-01-08 11:00:00	SPY	ETF	90.51	90.8	90.13	90.131	20877321.0
2009-01-08 11:30:00	SPY	ETF	90.141	90.23	89.88	90.01	14313082.0
2009-01-08 12:00:00	SPY	ETF	90.02	90.45	89.97	90.22	9244192.0
2009-01-08 12:30:00	SPY	ETF	90.22	90.53	90.09	90.21	9025738.0
2009-01-08 13:00:00	SPY	ETF	90.21	90.21	89.77	89.83	15184115.0
2009-01-08 13:30:00	SPY	ETF	89.83	90.17	89.75	90.08	10744962.0
2009-01-08 14:00:00	SPY	ETF	90.08	90.6	89.99	90.22	16399385.0
2009-01-08 14:30:00	SPY	ETF	90.22	90.85	90.01	90.7	18812508.0
2009-01-08 15:00:00	SPY	ETF	90.7	90.95	89.78	90.49	19483392.0
2009-01-08 15:30:00	SPY	ETF	90.49	91.09	90.24	91.08	36021766.0
2009-01-08 16:00:00	SPY	ETF	91.04	91.06	90.12	91.05	9648795.0
2009-01-08 16:30:00	SPY	ETF	91.05	91.05	90.1101	90.95	471336.0
2009-01-08 17:00:00	SPY	ETF	90.94	91.06	90.93	91.05	91384.0
2009-01-08 17:30:00	SPY	ETF	91.0	91.0	90.93	90.97	44874.0
2009-01-08 18:00:00	SPY	ETF	90.97	91.31	90.94	91.27	153354.0
2009-01-08 18:30:00	SPY	ETF	91.27	91.27	91.12	91.14	18288.0
2009-01-08 19:00:00	SPY	ETF	91.14	91.21	91.13	91.15	7651.0
2009-01-08 19:30:00	SPY	ETF	91.13	91.21	91.1	91.1	32226.0
2009-01-08 04:00:00	QQQ	ETF	30.56	30.56	30.56	30.56	100.0
2009-01-08 05:00:00	QQQ	ETF	30.45	30.45	30.45	30.45	100.0
2009-01-08 06:30:00	QQQ	ETF	30.5	30.5	30.5	30.5	100.0
2009-01-08 07:00:00	QQQ	ETF	30.56	30.65	30.52	30.55	211055.0
2009-01-08 07:30:00	QQQ	ETF	30.52	30.52	30.26	30.28	549021.0
2009-01-08 08:00:00	QQQ	ETF	30.3	30.3	30.14	30.22	2989054.0
2009-01-08 08:30:00	QQQ	ETF	30.24	30.39	30.21	30.33	874649.0
2009-01-08 09:00:00	QQQ	ETF	30.33	30.44	30.32	30.34	711179.0
2009-01-08 09:30:00	QQQ	ETF	30.34	30.4	30.11	30.18	13860743.0
2009-01-08 10:00:00	QQQ	ETF	30.18	30.27	30.08	30.26	9234298.0
2009-01-08 10:30:00	QQQ	ETF	30.2601	30.5	30.18	30.41	9585583.0
2009-01-08 11:00:00	QQQ	ETF	30.42	30.52	30.2911	30.2999	7734400.0
2009-01-08 11:30:00	QQQ	ETF	30.299	30.342	30.19	30.25	6531468.0
2009-01-08 12:00:00	QQQ	ETF	30.25	30.38	30.24	30.3	3700018.0
2009-01-08 12:30:00	QQQ	ETF	30.3001	30.42	30.24	30.309	3326928.0
2009-01-08 13:00:00	QQQ	ETF	30.31	30.33	30.16	30.22	5108146.0
2009-01-08 13:30:00	QQQ	ETF	30.22	30.36	30.19	30.33	3288084.0
2009-01-08 14:00:00	QQQ	ETF	30.33	30.59	30.3101	30.46	10180540.0

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

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