PREVIEW / etf_30min / 2007-10-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-19.parquet
  size:    143 KB
  rows:    5,215

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-10-19 04:00:00	SPY	ETF	152.96	152.96	152.96	152.96	1500.0
2007-10-19 05:00:00	SPY	ETF	152.96	152.96	152.96	152.96	15100.0
2007-10-19 05:30:00	SPY	ETF	152.93	153.08	152.88	153.08	24500.0
2007-10-19 06:00:00	SPY	ETF	153.22	153.24	153.18	153.18	5500.0
2007-10-19 06:30:00	SPY	ETF	153.35	153.4	153.28	153.39	48000.0
2007-10-19 07:00:00	SPY	ETF	153.41	153.5	153.32	153.46	115600.0
2007-10-19 07:30:00	SPY	ETF	153.42	153.43	153.22	153.31	866900.0
2007-10-19 08:00:00	SPY	ETF	153.36	153.41	153.08	153.25	2919400.0
2007-10-19 08:30:00	SPY	ETF	153.28	153.51	152.92	153.32	1765200.0
2007-10-19 09:00:00	SPY	ETF	153.32	153.32	152.96	153.09	1769731.0
2007-10-19 09:30:00	SPY	ETF	153.11	156.48	152.6	152.87	20078633.0
2007-10-19 10:00:00	SPY	ETF	152.87	153.012	152.23	152.55	25291900.0
2007-10-19 10:30:00	SPY	ETF	152.54	152.56	151.58	151.61	24511100.0
2007-10-19 11:00:00	SPY	ETF	151.61	152.08	151.6	151.91	14935900.0
2007-10-19 11:30:00	SPY	ETF	151.91	153.12	151.39	152.11	23833900.0
2007-10-19 12:00:00	SPY	ETF	152.1	152.29	151.87	151.92	10736696.0
2007-10-19 12:30:00	SPY	ETF	151.92	152.3	151.83	151.89	8172200.0
2007-10-19 13:00:00	SPY	ETF	151.88	151.92	151.43	151.54	11708600.0
2007-10-19 13:30:00	SPY	ETF	151.54	151.95	151.5	151.73	9998500.0
2007-10-19 14:00:00	SPY	ETF	151.73	151.73	151.09	151.41	21614100.0
2007-10-19 14:30:00	SPY	ETF	151.4	151.53	150.75	150.859	20515106.0
2007-10-19 15:00:00	SPY	ETF	150.85	153.9137	150.35	150.42	32440400.0
2007-10-19 15:30:00	SPY	ETF	150.44	150.78	149.9	149.97	44275400.0
2007-10-19 16:00:00	SPY	ETF	149.98	153.9137	149.64	149.64	9953400.0
2007-10-19 16:30:00	SPY	ETF	149.64	149.69	149.56	149.65	2543300.0
2007-10-19 17:00:00	SPY	ETF	149.6	153.9137	149.42	149.44	1164800.0
2007-10-19 17:30:00	SPY	ETF	149.46	149.67	149.4	149.41	612500.0
2007-10-19 18:00:00	SPY	ETF	149.45	151.54	149.27	149.35	35200.0
2007-10-19 18:30:00	SPY	ETF	149.36	149.44	149.35	149.39	12900.0
2007-10-19 19:00:00	SPY	ETF	149.39	149.43	149.37	149.42	2200.0
2007-10-19 19:30:00	SPY	ETF	149.45	149.59	149.4	149.43	16800.0
2007-10-19 05:30:00	QQQ	ETF	53.74	53.74	53.7	53.7	8000.0
2007-10-19 06:00:00	QQQ	ETF	53.72	53.74	53.72	53.74	2100.0
2007-10-19 06:30:00	QQQ	ETF	53.86	53.88	53.86	53.87	13900.0
2007-10-19 07:00:00	QQQ	ETF	53.93	54.1	53.89	54.04	121035.0
2007-10-19 07:30:00	QQQ	ETF	54.04	54.06	53.93	53.95	712470.0
2007-10-19 08:00:00	QQQ	ETF	53.95	54.1	53.84	53.87	2015632.0
2007-10-19 08:30:00	QQQ	ETF	53.87	53.96	53.53	53.88	1638265.0
2007-10-19 09:00:00	QQQ	ETF	53.88	53.88	53.72	53.76	1156841.0
2007-10-19 09:30:00	QQQ	ETF	53.77	53.77	53.38	53.45	28664461.0
2007-10-19 10:00:00	QQQ	ETF	53.45	53.47	53.06	53.21	15864291.0
2007-10-19 10:30:00	QQQ	ETF	53.22	53.22	52.72	52.74	21388818.0
2007-10-19 11:00:00	QQQ	ETF	52.74	53.05	52.74	53.02	15285391.0
2007-10-19 11:30:00	QQQ	ETF	53.01	53.16	52.79	53.09	16107114.0
2007-10-19 12:00:00	QQQ	ETF	53.0995	53.19	53.0	53.01	9245129.0
2007-10-19 12:30:00	QQQ	ETF	53.01	53.15	52.98	53.018	23280710.0
2007-10-19 13:00:00	QQQ	ETF	53.01	53.02	52.8	52.82	11027650.0
2007-10-19 13:30:00	QQQ	ETF	52.83	53.08	52.8285	52.97	10912568.0
2007-10-19 14:00:00	QQQ	ETF	52.972	53.03	52.75	52.88	14823018.0
2007-10-19 14:30:00	QQQ	ETF	52.89	52.96	52.73	52.79	11291989.0

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

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