PREVIEW / etf_30min / 2009-12-24

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-24.parquet
  size:    140 KB
  rows:    4,454

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
2009-12-24 04:30:00	SPY	ETF	112.15	112.25	112.15	112.25	1597.0
2009-12-24 05:00:00	SPY	ETF	112.27	112.33	112.26	112.33	3700.0
2009-12-24 05:30:00	SPY	ETF	112.29	112.29	112.29	112.29	100.0
2009-12-24 06:00:00	SPY	ETF	112.34	112.34	112.34	112.34	4000.0
2009-12-24 06:30:00	SPY	ETF	112.3	112.3	112.27	112.27	50000.0
2009-12-24 07:00:00	SPY	ETF	112.29	112.33	112.25	112.27	28300.0
2009-12-24 07:30:00	SPY	ETF	112.2	112.22	112.16	112.2	75360.0
2009-12-24 08:00:00	SPY	ETF	112.18	112.3	112.05	112.09	2289759.0
2009-12-24 08:30:00	SPY	ETF	112.1	112.3	112.06	112.19	416930.0
2009-12-24 09:00:00	SPY	ETF	112.19	112.22	111.9939	112.19	1393559.0
2009-12-24 09:30:00	SPY	ETF	112.19	112.42	112.18	112.3801	6339571.0
2009-12-24 10:00:00	SPY	ETF	112.38	112.6	112.38	112.52	5384689.0
2009-12-24 10:30:00	SPY	ETF	112.52	112.52	112.34	112.44	3147061.0
2009-12-24 11:00:00	SPY	ETF	112.4401	112.45	112.38	112.42	1528781.0
2009-12-24 11:30:00	SPY	ETF	112.41	112.5	112.41	112.48	1777426.0
2009-12-24 12:00:00	SPY	ETF	112.4795	112.53	112.43	112.47	2490485.0
2009-12-24 12:30:00	SPY	ETF	112.46	112.59	111.9948	112.57	10192084.0
2009-12-24 13:00:00	SPY	ETF	112.6	112.63	111.9948	112.63	4151306.0
2009-12-24 13:30:00	SPY	ETF	112.62	112.62	112.51	112.52	76430.0
2009-12-24 14:00:00	SPY	ETF	112.59	112.62	112.55	112.55	4600.0
2009-12-24 14:30:00	SPY	ETF	112.61	112.61	112.55	112.55	1900.0
2009-12-24 15:00:00	SPY	ETF	112.57	112.57	112.57	112.57	100.0
2009-12-24 15:30:00	SPY	ETF	112.57	112.59	112.55	112.59	894.0
2009-12-24 16:00:00	SPY	ETF	112.58	112.58	112.58	112.58	1000.0
2009-12-24 16:30:00	SPY	ETF	112.58	112.65	112.57	112.6	3600.0
2009-12-24 06:00:00	QQQ	ETF	45.68	45.68	45.68	45.68	100.0
2009-12-24 06:30:00	QQQ	ETF	45.68	45.68	45.68	45.68	300.0
2009-12-24 07:00:00	QQQ	ETF	45.66	45.66	45.64	45.64	11000.0
2009-12-24 07:30:00	QQQ	ETF	45.64	45.68	45.64	45.68	1169.0
2009-12-24 08:00:00	QQQ	ETF	45.67	45.69	45.6	45.63	1172977.0
2009-12-24 08:30:00	QQQ	ETF	45.64	45.69	45.61	45.65	537834.0
2009-12-24 09:00:00	QQQ	ETF	45.66	45.66	44.249	45.61	502760.0
2009-12-24 09:30:00	QQQ	ETF	45.61	45.8	45.6	45.7898	6318007.0
2009-12-24 10:00:00	QQQ	ETF	45.79	45.88	45.78	45.85	4626162.0
2009-12-24 10:30:00	QQQ	ETF	45.84	45.86	45.8	45.843	1844236.0
2009-12-24 11:00:00	QQQ	ETF	45.84	45.86	45.81	45.86	1433017.0
2009-12-24 11:30:00	QQQ	ETF	45.86	45.94	45.8595	45.93	4222457.0
2009-12-24 12:00:00	QQQ	ETF	45.93	45.96	45.89	45.9	2427755.0
2009-12-24 12:30:00	QQQ	ETF	45.9	45.98	45.89	45.97	4694685.0
2009-12-24 13:00:00	QQQ	ETF	45.98	46.01	45.6706	45.91	2548547.0
2009-12-24 13:30:00	QQQ	ETF	45.93	45.94	45.92	45.93	34960.0
2009-12-24 14:00:00	QQQ	ETF	45.93	45.95	45.92	45.95	1700.0
2009-12-24 14:30:00	QQQ	ETF	45.9	45.9	45.9	45.9	100.0
2009-12-24 15:00:00	QQQ	ETF	45.97	45.97	45.97	45.97	500.0
2009-12-24 15:30:00	QQQ	ETF	45.95	45.97	45.95	45.97	2345.0
2009-12-24 16:30:00	QQQ	ETF	45.95	45.97	45.91	45.97	600.0
2009-12-24 04:30:00	IWM	ETF	63.29	63.29	63.29	63.29	100.0
2009-12-24 07:00:00	IWM	ETF	63.35	63.35	63.35	63.35	5000.0
2009-12-24 07:30:00	IWM	ETF	63.33	63.33	63.33	63.33	200.0
2009-12-24 08:00:00	IWM	ETF	63.35	63.37	63.24	63.3	182240.0

> showing 50 of 4,454 rows — these rows as CSV

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