PREVIEW / etf_30min / 2008-01-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-15.parquet
  size:    157 KB
  rows:    5,710

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-01-15 04:00:00	SPY	ETF	140.71	140.71	140.68	140.68	4400.0
2008-01-15 04:30:00	SPY	ETF	140.69	140.69	140.53	140.53	4500.0
2008-01-15 05:00:00	SPY	ETF	140.5	140.5	140.42	140.5	19000.0
2008-01-15 05:30:00	SPY	ETF	140.5	140.65	140.5	140.65	55000.0
2008-01-15 06:00:00	SPY	ETF	140.51	140.52	140.51	140.51	50000.0
2008-01-15 06:30:00	SPY	ETF	140.44	140.99	140.36	140.73	305200.0
2008-01-15 07:00:00	SPY	ETF	140.73	140.88	140.45	140.54	1067000.0
2008-01-15 07:30:00	SPY	ETF	140.47	140.47	140.05	140.22	839600.0
2008-01-15 08:00:00	SPY	ETF	140.54	140.54	139.99	140.01	4291000.0
2008-01-15 08:30:00	SPY	ETF	139.99	140.2	139.61	139.69	5588700.0
2008-01-15 09:00:00	SPY	ETF	139.69	139.95	139.61	139.73	1730365.0
2008-01-15 09:30:00	SPY	ETF	139.75	140.58	139.67	139.86	17005412.0
2008-01-15 10:00:00	SPY	ETF	139.86	140.05	138.92	139.09	22445430.0
2008-01-15 10:30:00	SPY	ETF	139.09	139.3	138.36	138.64	22714363.0
2008-01-15 11:00:00	SPY	ETF	138.64	139.05	138.59	138.67	10614221.0
2008-01-15 11:30:00	SPY	ETF	138.672	138.77	138.24	138.64	12929249.0
2008-01-15 12:00:00	SPY	ETF	138.64	138.92	138.55	138.81	9604937.0
2008-01-15 12:30:00	SPY	ETF	138.81	138.87	138.37	138.66	8223519.0
2008-01-15 13:00:00	SPY	ETF	138.66	141.4903	138.51	138.64	12527683.0
2008-01-15 13:30:00	SPY	ETF	138.63	138.76	138.25	138.48	14412187.0
2008-01-15 14:00:00	SPY	ETF	138.48	138.84	138.31	138.53	9399240.0
2008-01-15 14:30:00	SPY	ETF	138.53	138.64	138.1	138.22	17841374.0
2008-01-15 15:00:00	SPY	ETF	138.22	138.83	137.92	138.7	24619653.0
2008-01-15 15:30:00	SPY	ETF	138.7	139.16	137.9	137.95	29830111.0
2008-01-15 16:00:00	SPY	ETF	138.0199	138.69	136.9	137.4	7062600.0
2008-01-15 16:30:00	SPY	ETF	137.39	137.46	136.74	136.77	2717075.0
2008-01-15 17:00:00	SPY	ETF	136.76	137.13	136.71	136.98	1416900.0
2008-01-15 17:30:00	SPY	ETF	136.98	137.05	136.89	136.96	133000.0
2008-01-15 18:00:00	SPY	ETF	136.94	136.99	136.8	136.97	244700.0
2008-01-15 18:30:00	SPY	ETF	136.96	137.04	136.89	136.9	81700.0
2008-01-15 19:00:00	SPY	ETF	136.86	137.01	136.81	136.81	16700.0
2008-01-15 19:30:00	SPY	ETF	136.81	136.89	136.74	136.85	15500.0
2008-01-15 04:00:00	QQQ	ETF	47.7	47.7	47.7	47.7	400.0
2008-01-15 04:30:00	QQQ	ETF	47.59	47.59	47.59	47.59	200.0
2008-01-15 05:30:00	QQQ	ETF	47.53	47.58	47.52	47.58	400.0
2008-01-15 06:00:00	QQQ	ETF	47.56	47.56	47.56	47.56	1500.0
2008-01-15 06:30:00	QQQ	ETF	47.59	47.68	47.57	47.62	81300.0
2008-01-15 07:00:00	QQQ	ETF	47.55	47.62	47.49	47.51	359588.0
2008-01-15 07:30:00	QQQ	ETF	47.5	47.51	47.31	47.38	436339.0
2008-01-15 08:00:00	QQQ	ETF	47.41	47.57	47.31	47.32	1949450.0
2008-01-15 08:30:00	QQQ	ETF	47.31	47.43	47.2	47.24	4931431.0
2008-01-15 09:00:00	QQQ	ETF	47.26	47.42	47.26	47.39	1588764.0
2008-01-15 09:30:00	QQQ	ETF	47.38	47.52	47.28	47.38	18076095.0
2008-01-15 10:00:00	QQQ	ETF	47.37	47.45	47.05	47.13	15290624.0
2008-01-15 10:30:00	QQQ	ETF	47.13	47.2	46.87	47.0	18765963.0
2008-01-15 11:00:00	QQQ	ETF	47.01	47.18	46.93	46.9501	13542172.0
2008-01-15 11:30:00	QQQ	ETF	46.96	47.05	46.82	47.01	11317354.0
2008-01-15 12:00:00	QQQ	ETF	47.01	47.06	46.88	46.97	7156186.0
2008-01-15 12:30:00	QQQ	ETF	46.97	47.0	46.67	46.79	14257232.0
2008-01-15 13:00:00	QQQ	ETF	46.79	47.02	46.72	46.8	11473532.0

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

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