PREVIEW / etf_30min / 2008-09-26

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-26.parquet
  size:    174 KB
  rows:    6,113

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-09-26 04:30:00	SPY	ETF	118.88	119.15	118.85	119.15	3600.0
2008-09-26 05:00:00	SPY	ETF	119.05	119.15	119.01	119.01	5000.0
2008-09-26 05:30:00	SPY	ETF	118.99	118.99	118.75	118.79	66100.0
2008-09-26 06:00:00	SPY	ETF	118.89	119.28	118.89	119.01	60799.0
2008-09-26 06:30:00	SPY	ETF	119.01	119.23	118.71	119.23	34090.0
2008-09-26 07:00:00	SPY	ETF	119.25	119.33	118.76	119.05	912351.0
2008-09-26 07:30:00	SPY	ETF	119.1	119.22	118.8	119.12	744990.0
2008-09-26 08:00:00	SPY	ETF	119.1	119.962	118.75	118.77	2628183.0
2008-09-26 08:30:00	SPY	ETF	118.75	119.21	118.21	118.39	3844429.0
2008-09-26 09:00:00	SPY	ETF	118.39	119.19	118.39	118.82	4273737.0
2008-09-26 09:30:00	SPY	ETF	118.83	119.78	118.51	119.2	35712274.0
2008-09-26 10:00:00	SPY	ETF	119.2	119.72	118.97	119.25	14828911.0
2008-09-26 10:30:00	SPY	ETF	119.25	120.01	119.1	119.67	17390353.0
2008-09-26 11:00:00	SPY	ETF	119.67	119.85	118.99	119.46	19932544.0
2008-09-26 11:30:00	SPY	ETF	119.44	120.79	118.8	118.97	13876182.0
2008-09-26 12:00:00	SPY	ETF	118.97	119.18	118.77	119.05	11462402.0
2008-09-26 12:30:00	SPY	ETF	119.06	119.64	119.02	119.58	12823228.0
2008-09-26 13:00:00	SPY	ETF	119.58	120.22	119.4	120.02	18546572.0
2008-09-26 13:30:00	SPY	ETF	120.01	120.52	119.87	120.04	14736603.0
2008-09-26 14:00:00	SPY	ETF	120.03	120.39	119.8	119.88	10629659.0
2008-09-26 14:30:00	SPY	ETF	119.88	120.25	119.5	119.76	14201097.0
2008-09-26 15:00:00	SPY	ETF	119.74	120.83	119.23	120.51	30982869.0
2008-09-26 15:30:00	SPY	ETF	120.5	121.5	120.41	121.36	42534013.0
2008-09-26 16:00:00	SPY	ETF	121.33	121.36	120.7907	121.3	8605688.0
2008-09-26 16:30:00	SPY	ETF	121.24	121.3	120.71	120.85	1209183.0
2008-09-26 17:00:00	SPY	ETF	120.86	121.15	120.7907	121.13	1138132.0
2008-09-26 17:30:00	SPY	ETF	121.13	121.35	121.05	121.31	68567.0
2008-09-26 18:00:00	SPY	ETF	121.3	121.31	121.09	121.24	86710.0
2008-09-26 18:30:00	SPY	ETF	121.15	121.34	121.15	121.27	10563.0
2008-09-26 19:00:00	SPY	ETF	121.3	121.39	121.25	121.3	31575.0
2008-09-26 19:30:00	SPY	ETF	121.35	121.48	121.35	121.48	12890.0
2008-09-26 04:30:00	QQQ	ETF	40.78	40.78	40.78	40.78	100.0
2008-09-26 05:00:00	QQQ	ETF	40.71	40.81	40.71	40.81	2100.0
2008-09-26 05:30:00	QQQ	ETF	40.78	40.84	40.77	40.82	4300.0
2008-09-26 06:00:00	QQQ	ETF	40.82	40.82	40.7	40.75	10000.0
2008-09-26 06:30:00	QQQ	ETF	40.68	40.68	40.56	40.67	11600.0
2008-09-26 07:00:00	QQQ	ETF	40.7	40.7	40.58	40.62	102000.0
2008-09-26 07:30:00	QQQ	ETF	40.64	40.75	40.61	40.73	294294.0
2008-09-26 08:00:00	QQQ	ETF	40.73	40.74	40.44	40.45	1306261.0
2008-09-26 08:30:00	QQQ	ETF	40.44	40.49	40.01	40.11	3227921.0
2008-09-26 09:00:00	QQQ	ETF	40.11	40.5	40.11	40.3	3814680.0
2008-09-26 09:30:00	QQQ	ETF	40.3	40.81	40.22	40.64	24686584.0
2008-09-26 10:00:00	QQQ	ETF	40.63	40.77	40.51	40.52	10554878.0
2008-09-26 10:30:00	QQQ	ETF	40.53	40.8	40.43	40.65	9984555.0
2008-09-26 11:00:00	QQQ	ETF	40.6522	40.73	40.44	40.62	9255936.0
2008-09-26 11:30:00	QQQ	ETF	40.61	40.67	40.49	40.53	4743594.0
2008-09-26 12:00:00	QQQ	ETF	40.53	40.56	40.4	40.52	5265421.0
2008-09-26 12:30:00	QQQ	ETF	40.52	40.77	40.5	40.71	8823759.0
2008-09-26 13:00:00	QQQ	ETF	40.72	41.09	40.72	41.0	19292506.0
2008-09-26 13:30:00	QQQ	ETF	40.99	41.09	40.79	40.831	10050595.0

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

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