PREVIEW / etf_30min / 2008-10-01

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-01.parquet
  size:    178 KB
  rows:    6,246

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-10-01 04:00:00	SPY	ETF	115.05	115.05	115.05	115.05	100.0
2008-10-01 04:30:00	SPY	ETF	115.14	115.34	115.14	115.34	1700.0
2008-10-01 05:00:00	SPY	ETF	115.46	115.46	115.1	115.11	3500.0
2008-10-01 05:30:00	SPY	ETF	115.14	115.28	114.96	114.96	48700.0
2008-10-01 06:00:00	SPY	ETF	114.88	115.22	114.87	115.22	17200.0
2008-10-01 06:30:00	SPY	ETF	115.2	115.7	115.15	115.7	18900.0
2008-10-01 07:00:00	SPY	ETF	115.56	116.0	115.44	115.7	570534.0
2008-10-01 07:30:00	SPY	ETF	115.84	115.85	115.35	115.35	345497.0
2008-10-01 08:00:00	SPY	ETF	115.36	115.79	115.0	115.42	1977007.0
2008-10-01 08:30:00	SPY	ETF	115.41	115.8	115.25	115.4	1976997.0
2008-10-01 09:00:00	SPY	ETF	115.41	115.47	115.15	115.18	2771020.0
2008-10-01 09:30:00	SPY	ETF	115.18	115.42	114.51	115.27	27099064.0
2008-10-01 10:00:00	SPY	ETF	115.26	115.28	114.06	114.7	27382215.0
2008-10-01 10:30:00	SPY	ETF	114.71	114.74	114.01	114.35	16552774.0
2008-10-01 11:00:00	SPY	ETF	114.34	116.5379	113.95	114.785	16482652.0
2008-10-01 11:30:00	SPY	ETF	114.79	115.13	114.62	114.93	15247949.0
2008-10-01 12:00:00	SPY	ETF	114.93	115.64	114.72	115.47	17638771.0
2008-10-01 12:30:00	SPY	ETF	115.47	116.64	115.41	116.21	35629622.0
2008-10-01 13:00:00	SPY	ETF	116.21	116.23	115.52	115.6499	23256860.0
2008-10-01 13:30:00	SPY	ETF	115.65	116.38	114.74	115.59	43840934.0
2008-10-01 14:00:00	SPY	ETF	115.58	116.28	115.16	116.25	23458071.0
2008-10-01 14:30:00	SPY	ETF	116.22	116.69	115.73	116.0	23879763.0
2008-10-01 15:00:00	SPY	ETF	116.01	116.38	115.59	115.89	15230558.0
2008-10-01 15:30:00	SPY	ETF	115.9	116.22	115.73	115.99	22261064.0
2008-10-01 16:00:00	SPY	ETF	115.98	116.56	115.83	116.22	8531840.0
2008-10-01 16:30:00	SPY	ETF	116.23	116.37	116.18	116.18	7230863.0
2008-10-01 17:00:00	SPY	ETF	116.19	116.4	116.19	116.37	123737.0
2008-10-01 17:30:00	SPY	ETF	116.4	116.4	116.35	116.38	3805.0
2008-10-01 18:00:00	SPY	ETF	116.38	116.75	116.32	116.68	255453.0
2008-10-01 18:30:00	SPY	ETF	116.6	116.66	116.55	116.58	10450.0
2008-10-01 19:00:00	SPY	ETF	116.6	116.76	116.55	116.75	18210.0
2008-10-01 19:30:00	SPY	ETF	116.77	116.77	116.42	116.42	29395.0
2008-10-01 04:00:00	QQQ	ETF	38.85	38.85	38.85	38.85	100.0
2008-10-01 06:00:00	QQQ	ETF	38.83	38.83	38.83	38.83	200.0
2008-10-01 06:30:00	QQQ	ETF	38.83	38.98	38.68	38.98	2800.0
2008-10-01 07:00:00	QQQ	ETF	38.98	39.09	38.95	39.05	92850.0
2008-10-01 07:30:00	QQQ	ETF	39.03	39.04	38.93	38.93	252902.0
2008-10-01 08:00:00	QQQ	ETF	39.02	39.02	38.66	38.75	1691698.0
2008-10-01 08:30:00	QQQ	ETF	38.74	38.88	38.68	38.78	812275.0
2008-10-01 09:00:00	QQQ	ETF	38.79	38.87	38.73	38.84	1245750.0
2008-10-01 09:30:00	QQQ	ETF	38.83	38.97	38.62	38.88	17456344.0
2008-10-01 10:00:00	QQQ	ETF	38.87	38.89	38.33	38.5199	19193416.0
2008-10-01 10:30:00	QQQ	ETF	38.51	38.51	38.11	38.2	12773737.0
2008-10-01 11:00:00	QQQ	ETF	38.19	38.38	38.03	38.27	9172377.0
2008-10-01 11:30:00	QQQ	ETF	38.27	38.43	38.19	38.34	7351096.0
2008-10-01 12:00:00	QQQ	ETF	38.33	38.61	38.2	38.46	11409603.0
2008-10-01 12:30:00	QQQ	ETF	38.46	38.92	38.4485	38.77	13515211.0
2008-10-01 13:00:00	QQQ	ETF	38.78	38.78	38.48	38.54	8060327.0
2008-10-01 13:30:00	QQQ	ETF	38.53	38.74	38.16	38.43	21391315.0
2008-10-01 14:00:00	QQQ	ETF	38.43	38.71	38.32	38.67	8623844.0

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

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