PREVIEW / etf_30min / 2008-04-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-23.parquet
  size:    161 KB
  rows:    5,670

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-04-23 04:30:00	SPY	ETF	138.41	138.41	138.34	138.34	300.0
2008-04-23 06:00:00	SPY	ETF	138.2	138.2	138.18	138.18	15000.0
2008-04-23 06:30:00	SPY	ETF	138.1	138.1	137.6	137.64	139700.0
2008-04-23 07:00:00	SPY	ETF	137.64	137.68	137.26	137.48	574908.0
2008-04-23 07:30:00	SPY	ETF	137.46	137.7	137.45	137.64	559675.0
2008-04-23 08:00:00	SPY	ETF	137.64	137.79	137.6	137.62	1063629.0
2008-04-23 08:30:00	SPY	ETF	137.63	137.93	137.63	137.82	903981.0
2008-04-23 09:00:00	SPY	ETF	137.79	138.16	137.75	138.1	2534505.0
2008-04-23 09:30:00	SPY	ETF	138.09	138.17	137.44	137.61	17614290.0
2008-04-23 10:00:00	SPY	ETF	137.62	138.05	137.42	138.039	16169106.0
2008-04-23 10:30:00	SPY	ETF	138.04	138.78	137.97	138.44	24944036.0
2008-04-23 11:00:00	SPY	ETF	138.43	138.57	138.28	138.34	12644754.0
2008-04-23 11:30:00	SPY	ETF	138.33	138.59	138.09	138.19	9638229.0
2008-04-23 12:00:00	SPY	ETF	138.19	138.2	137.56	137.67	11211934.0
2008-04-23 12:30:00	SPY	ETF	137.68	137.74	137.12	137.419	18727369.0
2008-04-23 13:00:00	SPY	ETF	137.43	137.72	137.29	137.68	12022092.0
2008-04-23 13:30:00	SPY	ETF	137.68	137.81	137.45	137.73	6480903.0
2008-04-23 14:00:00	SPY	ETF	137.73	137.87	137.56	137.66	6153324.0
2008-04-23 14:30:00	SPY	ETF	137.66	137.92	137.55	137.65	7787611.0
2008-04-23 15:00:00	SPY	ETF	137.65	138.16	137.63	137.82	16760282.0
2008-04-23 15:30:00	SPY	ETF	137.82	138.04	137.63	137.97	14397209.0
2008-04-23 16:00:00	SPY	ETF	137.94	138.55	137.2682	137.72	3249147.0
2008-04-23 16:30:00	SPY	ETF	137.72	138.1	137.15	137.23	6774681.0
2008-04-23 17:00:00	SPY	ETF	137.27	137.37	137.04	137.36	383349.0
2008-04-23 17:30:00	SPY	ETF	137.34	137.45	137.2	137.44	169216.0
2008-04-23 18:00:00	SPY	ETF	137.42	137.46	137.34	137.43	116266.0
2008-04-23 18:30:00	SPY	ETF	137.45	137.45	137.4	137.42	37700.0
2008-04-23 19:00:00	SPY	ETF	137.4	137.4	137.35	137.35	2800.0
2008-04-23 19:30:00	SPY	ETF	137.36	137.39	137.23	137.25	8937.0
2008-04-23 04:00:00	QQQ	ETF	46.6	46.6	46.6	46.6	5600.0
2008-04-23 04:30:00	QQQ	ETF	46.64	46.64	46.64	46.64	500.0
2008-04-23 06:00:00	QQQ	ETF	46.57	46.61	46.57	46.6	2300.0
2008-04-23 06:30:00	QQQ	ETF	46.61	46.61	46.5	46.52	2300.0
2008-04-23 07:00:00	QQQ	ETF	46.45	46.45	46.34	46.39	102565.0
2008-04-23 07:30:00	QQQ	ETF	46.39	46.61	46.39	46.56	1119679.0
2008-04-23 08:00:00	QQQ	ETF	46.52	46.59	46.46	46.55	1206978.0
2008-04-23 08:30:00	QQQ	ETF	46.53	46.64	46.53	46.61	268278.0
2008-04-23 09:00:00	QQQ	ETF	46.61	46.77	46.61	46.69	868672.0
2008-04-23 09:30:00	QQQ	ETF	46.69	46.71	46.44	46.62	9723819.0
2008-04-23 10:00:00	QQQ	ETF	46.62	46.9	46.55	46.8795	10221462.0
2008-04-23 10:30:00	QQQ	ETF	46.87	47.06	46.8	46.961	12617762.0
2008-04-23 11:00:00	QQQ	ETF	46.9695	47.05	46.9101	46.94	5359781.0
2008-04-23 11:30:00	QQQ	ETF	46.95	47.03	46.9	46.9225	4951754.0
2008-04-23 12:00:00	QQQ	ETF	46.92	46.925	46.6	46.67	8889515.0
2008-04-23 12:30:00	QQQ	ETF	46.67	46.7	46.53	46.63	5037151.0
2008-04-23 13:00:00	QQQ	ETF	46.62	46.8	46.57	46.781	3652909.0
2008-04-23 13:30:00	QQQ	ETF	46.782	46.84	46.67	46.81	3713516.0
2008-04-23 14:00:00	QQQ	ETF	46.802	46.88	46.75	46.77	3666650.0
2008-04-23 14:30:00	QQQ	ETF	46.77	46.88	46.75	46.76	4742727.0
2008-04-23 15:00:00	QQQ	ETF	46.75	46.95	46.75	46.83	9184903.0

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

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