PREVIEW / etf_30min / 2008-11-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-18.parquet
  size:    179 KB
  rows:    6,326

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-11-18 04:00:00	SPY	ETF	83.81	84.0	83.66	83.7	3748.0
2008-11-18 04:30:00	SPY	ETF	83.82	84.08	83.6	83.7	7125.0
2008-11-18 05:00:00	SPY	ETF	83.68	84.14	83.68	84.14	2050.0
2008-11-18 05:30:00	SPY	ETF	83.89	84.13	83.88	84.13	2700.0
2008-11-18 06:00:00	SPY	ETF	84.1	84.11	83.78	83.78	8300.0
2008-11-18 06:30:00	SPY	ETF	83.76	84.02	83.4	83.92	38850.0
2008-11-18 07:00:00	SPY	ETF	83.89	84.27	83.84	84.05	364879.0
2008-11-18 07:30:00	SPY	ETF	84.09	84.23	83.8	84.05	398135.0
2008-11-18 08:00:00	SPY	ETF	84.06	85.05	83.75	84.8	4381326.0
2008-11-18 08:30:00	SPY	ETF	84.76	85.38	84.53	84.98	4542402.0
2008-11-18 09:00:00	SPY	ETF	84.98	85.47	84.76	85.14	4332491.0
2008-11-18 09:30:00	SPY	ETF	85.15	86.24	84.83	85.5888	46970329.0
2008-11-18 10:00:00	SPY	ETF	85.58	86.83	84.84	86.83	37475604.0
2008-11-18 10:30:00	SPY	ETF	86.83	86.85	85.93	86.16	25269573.0
2008-11-18 11:00:00	SPY	ETF	86.16	86.18	85.48	85.91	20753158.0
2008-11-18 11:30:00	SPY	ETF	85.92	87.0	85.81	86.9	19944687.0
2008-11-18 12:00:00	SPY	ETF	86.9	86.9	85.82	85.99	19016352.0
2008-11-18 12:30:00	SPY	ETF	86.01	86.01	85.1	85.38	18474090.0
2008-11-18 13:00:00	SPY	ETF	85.37	85.39	84.26	84.8	28233455.0
2008-11-18 13:30:00	SPY	ETF	84.8	84.81	83.48	84.64	47302527.0
2008-11-18 14:00:00	SPY	ETF	84.64	86.35	83.58	84.39	41300972.0
2008-11-18 14:30:00	SPY	ETF	84.37	84.6	82.91	83.21	36120078.0
2008-11-18 15:00:00	SPY	ETF	83.2	85.1	83.1	84.46	58031315.0
2008-11-18 15:30:00	SPY	ETF	84.44	86.26	83.69	86.2	87505972.0
2008-11-18 16:00:00	SPY	ETF	86.2	87.25	83.955	86.83	15223882.0
2008-11-18 16:30:00	SPY	ETF	86.83	86.91	85.3871	86.8	4644554.0
2008-11-18 17:00:00	SPY	ETF	86.8	86.9	85.3871	86.69	1139986.0
2008-11-18 17:30:00	SPY	ETF	86.74	86.75	86.63	86.65	124690.0
2008-11-18 18:00:00	SPY	ETF	86.65	86.69	86.51	86.51	701605.0
2008-11-18 18:30:00	SPY	ETF	86.53	86.59	86.42	86.42	42599.0
2008-11-18 19:00:00	SPY	ETF	86.4	86.5	86.3	86.42	46936.0
2008-11-18 19:30:00	SPY	ETF	86.45	86.45	86.12	86.18	67975.0
2008-11-18 04:00:00	QQQ	ETF	27.97	27.97	27.97	27.97	100.0
2008-11-18 04:30:00	QQQ	ETF	27.99	27.99	27.99	27.99	100.0
2008-11-18 05:00:00	QQQ	ETF	27.94	27.94	27.94	27.94	200.0
2008-11-18 05:30:00	QQQ	ETF	27.93	27.93	27.93	27.93	1050.0
2008-11-18 06:00:00	QQQ	ETF	27.95	27.96	27.9	27.9	5500.0
2008-11-18 06:30:00	QQQ	ETF	27.88	27.9	27.83	27.9	11500.0
2008-11-18 07:00:00	QQQ	ETF	27.9	28.1	27.9	28.04	248342.0
2008-11-18 07:30:00	QQQ	ETF	28.1	28.1	27.93	28.01	115530.0
2008-11-18 08:00:00	QQQ	ETF	28.02	28.43	27.94	28.4	2384740.0
2008-11-18 08:30:00	QQQ	ETF	28.38	28.68	28.31	28.54	2859414.0
2008-11-18 09:00:00	QQQ	ETF	28.54	28.63	28.41	28.55	738729.0
2008-11-18 09:30:00	QQQ	ETF	28.56	28.75	28.28	28.41	25341776.0
2008-11-18 10:00:00	QQQ	ETF	28.41	28.7099	28.19	28.7	19449439.0
2008-11-18 10:30:00	QQQ	ETF	28.71	28.71	28.4	28.53	13065624.0
2008-11-18 11:00:00	QQQ	ETF	28.53	28.54	28.25	28.31	13067403.0
2008-11-18 11:30:00	QQQ	ETF	28.32	28.65	28.29	28.6399	11436378.0
2008-11-18 12:00:00	QQQ	ETF	28.63	28.63	28.3	28.36	7958876.0
2008-11-18 12:30:00	QQQ	ETF	28.36	28.36	28.11	28.15	11207308.0

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

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