PREVIEW / etf_30min / 2008-01-11

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-11.parquet
  size:    153 KB
  rows:    5,510

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-11 04:00:00	SPY	ETF	140.6	140.6	140.41	140.49	3100.0
2008-01-11 04:30:00	SPY	ETF	140.62	140.75	140.62	140.75	2000.0
2008-01-11 05:00:00	SPY	ETF	140.6	140.6	140.54	140.54	1200.0
2008-01-11 05:30:00	SPY	ETF	140.64	140.7	140.51	140.51	66000.0
2008-01-11 06:00:00	SPY	ETF	140.48	140.48	140.39	140.39	35200.0
2008-01-11 06:30:00	SPY	ETF	140.38	140.38	139.85	140.06	177400.0
2008-01-11 07:00:00	SPY	ETF	140.12	140.48	140.05	140.15	1531800.0
2008-01-11 07:30:00	SPY	ETF	140.12	141.3	139.9	140.58	2549000.0
2008-01-11 08:00:00	SPY	ETF	140.58	140.77	140.13	140.49	1616900.0
2008-01-11 08:30:00	SPY	ETF	140.49	140.85	139.9	140.68	4734405.0
2008-01-11 09:00:00	SPY	ETF	140.68	140.91	140.6	140.72	1750352.0
2008-01-11 09:30:00	SPY	ETF	140.78	141.13	140.0	140.69	26600849.0
2008-01-11 10:00:00	SPY	ETF	140.68	140.71	140.2	140.5	15651958.0
2008-01-11 10:30:00	SPY	ETF	140.5	141.35	140.27	141.01	21200157.0
2008-01-11 11:00:00	SPY	ETF	141.01	141.12	140.65	141.05	13145606.0
2008-01-11 11:30:00	SPY	ETF	141.04	141.57	141.01	141.18	18739806.0
2008-01-11 12:00:00	SPY	ETF	141.18	141.31	140.53	140.8	13816583.0
2008-01-11 12:30:00	SPY	ETF	140.8	141.8985	140.51	141.26	11750633.0
2008-01-11 13:00:00	SPY	ETF	141.26	141.31	140.08	140.55	17354541.0
2008-01-11 13:30:00	SPY	ETF	140.55	140.66	139.93	140.14	27709290.0
2008-01-11 14:00:00	SPY	ETF	140.14	140.69	140.0	140.47	11225069.0
2008-01-11 14:30:00	SPY	ETF	140.4601	141.8978	139.77	140.19	13193684.0
2008-01-11 15:00:00	SPY	ETF	140.19	140.19	139.0	140.01	29379103.0
2008-01-11 15:30:00	SPY	ETF	139.99	140.51	139.71	140.01	26404214.0
2008-01-11 16:00:00	SPY	ETF	140.098	140.3192	139.98	140.18	3827200.0
2008-01-11 16:30:00	SPY	ETF	140.18	140.2	140.01	140.04	91900.0
2008-01-11 17:00:00	SPY	ETF	140.04	140.12	140.03	140.08	146100.0
2008-01-11 17:30:00	SPY	ETF	140.1	140.16	140.1	140.16	11100.0
2008-01-11 18:00:00	SPY	ETF	140.16	140.19	140.1	140.15	25600.0
2008-01-11 18:30:00	SPY	ETF	140.15	140.21	140.15	140.21	10900.0
2008-01-11 19:00:00	SPY	ETF	140.22	140.29	140.22	140.25	8800.0
2008-01-11 19:30:00	SPY	ETF	140.26	140.26	140.2	140.26	9500.0
2008-01-11 06:00:00	QQQ	ETF	47.71	47.72	47.69	47.72	51500.0
2008-01-11 06:30:00	QQQ	ETF	47.65	47.65	47.52	47.52	1200.0
2008-01-11 07:00:00	QQQ	ETF	47.58	47.73	47.5	47.59	414600.0
2008-01-11 07:30:00	QQQ	ETF	47.57	47.71	47.44	47.66	560877.0
2008-01-11 08:00:00	QQQ	ETF	47.66	47.7	47.47	47.62	613670.0
2008-01-11 08:30:00	QQQ	ETF	47.61	47.72	47.52	47.68	919021.0
2008-01-11 09:00:00	QQQ	ETF	47.67	47.79	47.63	47.72	1000746.0
2008-01-11 09:30:00	QQQ	ETF	47.72	47.77	47.49	47.56	14566458.0
2008-01-11 10:00:00	QQQ	ETF	47.55	47.61	47.4	47.46	13981101.0
2008-01-11 10:30:00	QQQ	ETF	47.46	47.61	47.34	47.46	17171731.0
2008-01-11 11:00:00	QQQ	ETF	47.468	47.5	47.3	47.48	10426892.0
2008-01-11 11:30:00	QQQ	ETF	47.47	47.67	47.43	47.5	12230103.0
2008-01-11 12:00:00	QQQ	ETF	47.5	47.58	47.24	47.32	10270265.0
2008-01-11 12:30:00	QQQ	ETF	47.319	47.46	47.23	47.45	9339092.0
2008-01-11 13:00:00	QQQ	ETF	47.45	47.47	47.0401	47.23	18937130.0
2008-01-11 13:30:00	QQQ	ETF	47.23	47.269	47.0	47.0	13356323.0
2008-01-11 14:00:00	QQQ	ETF	47.0	47.28	46.98	47.1616	10277314.0
2008-01-11 14:30:00	QQQ	ETF	47.1699	47.19	46.88	47.04	13065141.0

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

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