PREVIEW / etf_30min / 2008-08-06

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-06.parquet
  size:    168 KB
  rows:    5,871

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-08-06 04:00:00	SPY	ETF	128.4	128.4	128.4	128.4	400.0
2008-08-06 05:30:00	SPY	ETF	128.26	128.26	128.21	128.26	600.0
2008-08-06 06:00:00	SPY	ETF	128.19	128.19	128.0	128.0	58300.0
2008-08-06 06:30:00	SPY	ETF	128.05	128.1	127.91	128.1	65400.0
2008-08-06 07:00:00	SPY	ETF	128.1	128.2	128.0	128.02	293050.0
2008-08-06 07:30:00	SPY	ETF	128.05	128.14	127.98	128.03	725499.0
2008-08-06 08:00:00	SPY	ETF	128.05	128.28	128.0	128.07	1416328.0
2008-08-06 08:30:00	SPY	ETF	128.06	128.21	127.98	128.18	662313.0
2008-08-06 09:00:00	SPY	ETF	128.15	128.18	128.01	128.03	1332192.0
2008-08-06 09:30:00	SPY	ETF	128.02	128.26	127.78	128.07	24585697.0
2008-08-06 10:00:00	SPY	ETF	128.08	128.23	127.94	128.03	12486024.0
2008-08-06 10:30:00	SPY	ETF	128.03	128.6123	127.48	127.85	19848333.0
2008-08-06 11:00:00	SPY	ETF	127.84	128.36	127.71	128.31	17529037.0
2008-08-06 11:30:00	SPY	ETF	128.32	128.46	128.18	128.32	14731834.0
2008-08-06 12:00:00	SPY	ETF	128.33	128.56	128.26	128.52	12495768.0
2008-08-06 12:30:00	SPY	ETF	128.52	128.73	128.36	128.435	10866950.0
2008-08-06 13:00:00	SPY	ETF	128.44	128.63	128.25	128.55	7168837.0
2008-08-06 13:30:00	SPY	ETF	128.55	128.67	128.28	128.46	10737362.0
2008-08-06 14:00:00	SPY	ETF	128.47	128.89	128.375	128.76	13197578.0
2008-08-06 14:30:00	SPY	ETF	128.76	129.3	128.75	129.18	17793406.0
2008-08-06 15:00:00	SPY	ETF	129.19	129.28	129.0	129.01	15327631.0
2008-08-06 15:30:00	SPY	ETF	129.01	129.16	128.8	129.09	20820623.0
2008-08-06 16:00:00	SPY	ETF	129.09	129.1565	128.6124	128.94	4056855.0
2008-08-06 16:30:00	SPY	ETF	128.99	129.04	128.85	128.9	945469.0
2008-08-06 17:00:00	SPY	ETF	128.92	128.94	128.5	128.6	567106.0
2008-08-06 17:30:00	SPY	ETF	128.58	128.75	128.5	128.55	149850.0
2008-08-06 18:00:00	SPY	ETF	128.6	128.63	128.53	128.55	85321.0
2008-08-06 18:30:00	SPY	ETF	128.59	128.6	128.52	128.52	12200.0
2008-08-06 19:00:00	SPY	ETF	128.51	128.53	128.5	128.53	21417.0
2008-08-06 19:30:00	SPY	ETF	128.52	128.63	128.49	128.51	26151.0
2008-08-06 20:00:00	SPY	ETF	128.51	128.51	128.51	128.51	500.0
2008-08-06 04:00:00	QQQ	ETF	46.04	46.04	46.04	46.04	100.0
2008-08-06 06:00:00	QQQ	ETF	46.0	46.0	46.0	46.0	1200.0
2008-08-06 06:30:00	QQQ	ETF	46.0	46.0	45.96	45.96	1200.0
2008-08-06 07:00:00	QQQ	ETF	46.02	46.07	45.98	45.99	132355.0
2008-08-06 07:30:00	QQQ	ETF	46.0	46.05	45.99	46.0	83337.0
2008-08-06 08:00:00	QQQ	ETF	45.99	46.09	45.99	46.0	2609690.0
2008-08-06 08:30:00	QQQ	ETF	46.0	46.0	45.96	46.0	1097284.0
2008-08-06 09:00:00	QQQ	ETF	45.98	46.0	45.92	45.93	1025111.0
2008-08-06 09:30:00	QQQ	ETF	45.93	45.99	45.7	45.85	14994198.0
2008-08-06 10:00:00	QQQ	ETF	45.8599	45.89	45.68	45.76	6337349.0
2008-08-06 10:30:00	QQQ	ETF	45.76	45.8	45.58	45.69	12180656.0
2008-08-06 11:00:00	QQQ	ETF	45.69	46.19	45.6	46.18	14196897.0
2008-08-06 11:30:00	QQQ	ETF	46.18	46.23	46.08	46.22	9376494.0
2008-08-06 12:00:00	QQQ	ETF	46.22	46.35	46.19	46.31	6800295.0
2008-08-06 12:30:00	QQQ	ETF	46.31	46.43	46.2	46.26	6309622.0
2008-08-06 13:00:00	QQQ	ETF	46.25	46.42	46.2	46.4005	3088871.0
2008-08-06 13:30:00	QQQ	ETF	46.41	46.48	46.22	46.34	7372564.0
2008-08-06 14:00:00	QQQ	ETF	46.34	46.54	46.31	46.51	6028064.0
2008-08-06 14:30:00	QQQ	ETF	46.505	46.81	46.5	46.7	11966204.0

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

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