PREVIEW / etf_30min / 2008-03-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-25.parquet
  size:    156 KB
  rows:    5,665

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
2008-03-25 05:00:00	SPY	ETF	134.57	134.58	134.54	134.58	12000.0
2008-03-25 05:30:00	SPY	ETF	134.5	134.56	134.5	134.56	5600.0
2008-03-25 06:00:00	SPY	ETF	134.56	134.58	134.56	134.56	12000.0
2008-03-25 06:30:00	SPY	ETF	134.86	135.27	134.82	135.24	142000.0
2008-03-25 07:00:00	SPY	ETF	135.16	135.5	135.16	135.5	220400.0
2008-03-25 07:30:00	SPY	ETF	135.43	135.62	135.32	135.45	527500.0
2008-03-25 08:00:00	SPY	ETF	135.45	135.48	134.79	135.14	1386700.0
2008-03-25 08:30:00	SPY	ETF	135.15	135.61	134.7	134.77	1962800.0
2008-03-25 09:00:00	SPY	ETF	134.75	135.03	134.73	134.82	2799864.0
2008-03-25 09:30:00	SPY	ETF	134.86	135.33	134.25	134.3	23386050.0
2008-03-25 10:00:00	SPY	ETF	134.27	135.0	133.77	134.15	27870170.0
2008-03-25 10:30:00	SPY	ETF	134.15	134.6	133.96	134.4	12215109.0
2008-03-25 11:00:00	SPY	ETF	134.4	134.82	134.28	134.69	11225979.0
2008-03-25 11:30:00	SPY	ETF	134.69	134.93	134.4	134.46	8341885.0
2008-03-25 12:00:00	SPY	ETF	134.48	135.12	134.32	135.05	9597960.0
2008-03-25 12:30:00	SPY	ETF	135.05	135.22	134.83	134.94	9661431.0
2008-03-25 13:00:00	SPY	ETF	134.94	135.12	134.77	135.09	4755029.0
2008-03-25 13:30:00	SPY	ETF	135.1	135.49	134.99	135.43	9214292.0
2008-03-25 14:00:00	SPY	ETF	135.43	135.55	135.12	135.22	6339406.0
2008-03-25 14:30:00	SPY	ETF	135.21	135.52	134.96	135.39	10445328.0
2008-03-25 15:00:00	SPY	ETF	135.39	135.55	135.16	135.3406	11434421.0
2008-03-25 15:30:00	SPY	ETF	135.34	135.48	134.82	135.05	28135141.0
2008-03-25 16:00:00	SPY	ETF	135.05	135.54	134.7	134.7	6325500.0
2008-03-25 16:30:00	SPY	ETF	134.72	134.82	134.7	134.7	4446500.0
2008-03-25 17:00:00	SPY	ETF	134.7	134.72	134.57	134.68	69400.0
2008-03-25 17:30:00	SPY	ETF	134.6	134.73	134.56	134.65	13900.0
2008-03-25 18:00:00	SPY	ETF	134.65	134.67	134.55	134.57	7500.0
2008-03-25 18:30:00	SPY	ETF	134.61	134.7	134.61	134.7	7800.0
2008-03-25 19:00:00	SPY	ETF	134.66	134.66	134.44	134.47	43600.0
2008-03-25 19:30:00	SPY	ETF	134.48	134.52	134.41	134.49	25900.0
2008-03-25 05:00:00	QQQ	ETF	44.56	44.56	44.56	44.56	400.0
2008-03-25 05:30:00	QQQ	ETF	44.5	44.5	44.5	44.5	1000.0
2008-03-25 07:00:00	QQQ	ETF	44.72	44.81	44.72	44.79	33098.0
2008-03-25 07:30:00	QQQ	ETF	44.8	44.84	44.76	44.81	60396.0
2008-03-25 08:00:00	QQQ	ETF	44.81	44.84	44.77	44.79	1633077.0
2008-03-25 08:30:00	QQQ	ETF	44.8	44.8	44.68	44.68	282096.0
2008-03-25 09:00:00	QQQ	ETF	44.69	44.71	44.64	44.66	689428.0
2008-03-25 09:30:00	QQQ	ETF	44.68	44.83	44.43	44.44	16005503.0
2008-03-25 10:00:00	QQQ	ETF	44.44	44.57	44.28	44.45	15231068.0
2008-03-25 10:30:00	QQQ	ETF	44.45	44.67	44.39	44.55	9292892.0
2008-03-25 11:00:00	QQQ	ETF	44.56	44.74	44.52	44.69	5774182.0
2008-03-25 11:30:00	QQQ	ETF	44.68	44.74	44.5	44.532	7574126.0
2008-03-25 12:00:00	QQQ	ETF	44.54	44.77	44.48	44.75	4404765.0
2008-03-25 12:30:00	QQQ	ETF	44.75	44.77	44.63	44.65	4612332.0
2008-03-25 13:00:00	QQQ	ETF	44.66	44.721	44.57	44.72	5003717.0
2008-03-25 13:30:00	QQQ	ETF	44.72	44.99	44.7	44.95	8095425.0
2008-03-25 14:00:00	QQQ	ETF	44.95	44.99	44.84	44.872	4345269.0
2008-03-25 14:30:00	QQQ	ETF	44.88	45.0	44.8	44.99	6202323.0
2008-03-25 15:00:00	QQQ	ETF	44.99	45.07	44.9	45.02	6528060.0
2008-03-25 15:30:00	QQQ	ETF	45.012	45.0501	44.81	44.83	7125255.0

> showing 50 of 5,665 rows — these rows as CSV

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