PREVIEW / etf_30min / 2007-05-08

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-08.parquet
  size:    108 KB
  rows:    3,952

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
2007-05-08 05:00:00	SPY	ETF	150.65	150.65	150.65	150.65	500.0
2007-05-08 05:30:00	SPY	ETF	150.53	150.53	150.53	150.53	500.0
2007-05-08 06:00:00	SPY	ETF	150.55	150.55	150.55	150.55	8000.0
2007-05-08 06:30:00	SPY	ETF	150.53	150.54	150.5	150.54	11200.0
2007-05-08 07:00:00	SPY	ETF	150.54	150.57	150.43	150.46	175700.0
2007-05-08 07:30:00	SPY	ETF	150.48	150.52	150.39	150.5	61000.0
2007-05-08 08:00:00	SPY	ETF	150.49	150.61	150.47	150.51	1872700.0
2007-05-08 08:30:00	SPY	ETF	150.51	150.64	150.48	150.56	705100.0
2007-05-08 09:00:00	SPY	ETF	150.56	150.61	150.51	150.57	554100.0
2007-05-08 09:30:00	SPY	ETF	150.56	150.62	150.32	150.39	12220413.0
2007-05-08 10:00:00	SPY	ETF	150.39	150.43	150.13	150.34	10942968.0
2007-05-08 10:30:00	SPY	ETF	150.34	150.43	150.2	150.39	6809501.0
2007-05-08 11:00:00	SPY	ETF	150.4	150.43	150.24	150.33	3795502.0
2007-05-08 11:30:00	SPY	ETF	150.34	150.45	150.24	150.31	2224100.0
2007-05-08 12:00:00	SPY	ETF	150.32	150.44	150.24	150.37	3594792.0
2007-05-08 12:30:00	SPY	ETF	150.37	150.75	150.36	150.69	6465450.0
2007-05-08 13:00:00	SPY	ETF	150.69	150.79	150.61	150.69	4861650.0
2007-05-08 13:30:00	SPY	ETF	150.68	150.73	150.61	150.66	3271593.0
2007-05-08 14:00:00	SPY	ETF	150.66	150.88	150.58	150.83	4742721.0
2007-05-08 14:30:00	SPY	ETF	150.84	150.87	150.65	150.66	4454141.0
2007-05-08 15:00:00	SPY	ETF	150.67	150.9	150.64	150.85	4228200.0
2007-05-08 15:30:00	SPY	ETF	150.85	150.92	150.77	150.86	5944505.0
2007-05-08 16:00:00	SPY	ETF	150.87	150.92	150.75	150.78	1662200.0
2007-05-08 16:30:00	SPY	ETF	150.75	150.79	150.64	150.67	544600.0
2007-05-08 17:00:00	SPY	ETF	150.66	150.68	150.57	150.59	205300.0
2007-05-08 17:30:00	SPY	ETF	150.6	150.6	150.59	150.59	735000.0
2007-05-08 18:00:00	SPY	ETF	150.59	150.72	150.57	150.69	213600.0
2007-05-08 18:30:00	SPY	ETF	150.69	150.69	150.67	150.67	1500.0
2007-05-08 19:00:00	SPY	ETF	150.65	150.65	150.65	150.65	2000.0
2007-05-08 19:30:00	SPY	ETF	150.65	150.65	150.61	150.65	2900.0
2007-05-08 06:00:00	QQQ	ETF	46.49	46.49	46.49	46.49	5000.0
2007-05-08 07:00:00	QQQ	ETF	46.48	46.49	46.43	46.44	400000.0
2007-05-08 07:30:00	QQQ	ETF	46.45	46.46	46.4	46.43	1061892.0
2007-05-08 08:00:00	QQQ	ETF	46.44	46.48	46.42	46.44	518369.0
2007-05-08 08:30:00	QQQ	ETF	46.45	46.56	46.43	46.53	1881189.0
2007-05-08 09:00:00	QQQ	ETF	46.52	46.53	46.46	46.47	1033990.0
2007-05-08 09:30:00	QQQ	ETF	46.47	46.52	46.36	46.42	12693115.0
2007-05-08 10:00:00	QQQ	ETF	46.42	46.45	46.3	46.42	9558890.0
2007-05-08 10:30:00	QQQ	ETF	46.41	46.56	46.4	46.52	8742622.0
2007-05-08 11:00:00	QQQ	ETF	46.52	46.54	46.46	46.52	4480644.0
2007-05-08 11:30:00	QQQ	ETF	46.52	46.55	46.46	46.47	2734107.0
2007-05-08 12:00:00	QQQ	ETF	46.48	46.52	46.44	46.47	4137219.0
2007-05-08 12:30:00	QQQ	ETF	46.46	46.63	46.46	46.6	5295069.0
2007-05-08 13:00:00	QQQ	ETF	46.61	46.71	46.57	46.65	8370835.0
2007-05-08 13:30:00	QQQ	ETF	46.66	46.66	46.61	46.61	2509580.0
2007-05-08 14:00:00	QQQ	ETF	46.61	46.77	46.59	46.73	6982900.0
2007-05-08 14:30:00	QQQ	ETF	46.73	46.74	46.61	46.62	3420883.0
2007-05-08 15:00:00	QQQ	ETF	46.62	46.71	46.62	46.69	2785151.0
2007-05-08 15:30:00	QQQ	ETF	46.69	46.74	46.66	46.73	6921295.0
2007-05-08 16:00:00	QQQ	ETF	46.72	46.78	46.55	46.66	5073345.0

> showing 50 of 3,952 rows — these rows as CSV

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