PREVIEW / etf_30min / 2007-11-29

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-29.parquet
  size:    139 KB
  rows:    5,142

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
2007-11-29 04:30:00	SPY	ETF	146.62	146.62	146.62	146.62	500.0
2007-11-29 05:00:00	SPY	ETF	146.54	146.73	146.54	146.73	1600.0
2007-11-29 05:30:00	SPY	ETF	146.56	146.9	146.56	146.81	28300.0
2007-11-29 06:00:00	SPY	ETF	146.5	146.67	146.31	146.57	11500.0
2007-11-29 06:30:00	SPY	ETF	146.47	146.71	146.44	146.53	70200.0
2007-11-29 07:00:00	SPY	ETF	146.45	146.55	146.27	146.39	358500.0
2007-11-29 07:30:00	SPY	ETF	146.4	146.96	146.27	146.89	487100.0
2007-11-29 08:00:00	SPY	ETF	146.9	147.0	146.31	146.52	3048800.0
2007-11-29 08:30:00	SPY	ETF	146.54	146.88	146.46	146.82	808200.0
2007-11-29 09:00:00	SPY	ETF	146.83	146.91	146.27	146.61	2862000.0
2007-11-29 09:30:00	SPY	ETF	146.62	147.15	146.45	146.62	24717611.0
2007-11-29 10:00:00	SPY	ETF	146.62	146.89	146.1	146.51	18853918.0
2007-11-29 10:30:00	SPY	ETF	146.52	146.92	146.38	146.83	10859397.0
2007-11-29 11:00:00	SPY	ETF	146.84	147.14	146.72	147.09	12648710.0
2007-11-29 11:30:00	SPY	ETF	147.09	147.72	147.07	147.46	20515368.0
2007-11-29 12:00:00	SPY	ETF	147.46	147.63	147.1	147.34	8162248.0
2007-11-29 12:30:00	SPY	ETF	147.34	147.47	146.83	146.89	10433283.0
2007-11-29 13:00:00	SPY	ETF	146.89	147.08	146.64	146.7	11258752.0
2007-11-29 13:30:00	SPY	ETF	146.7	147.07	146.3	146.89	13347537.0
2007-11-29 14:00:00	SPY	ETF	146.88	147.27	146.65	147.19	10335700.0
2007-11-29 14:30:00	SPY	ETF	147.19	147.32	146.85	147.19	8993700.0
2007-11-29 15:00:00	SPY	ETF	147.2	147.48	146.98	147.26	13312237.0
2007-11-29 15:30:00	SPY	ETF	147.27	147.5	146.88	147.27	16248136.0
2007-11-29 16:00:00	SPY	ETF	147.22	147.72	146.6663	147.05	5017300.0
2007-11-29 16:30:00	SPY	ETF	147.1	147.2	147.0	147.1	3641900.0
2007-11-29 17:00:00	SPY	ETF	147.15	147.18	147.03	147.14	615600.0
2007-11-29 17:30:00	SPY	ETF	147.09	147.09	146.93	147.0	59600.0
2007-11-29 18:00:00	SPY	ETF	147.0	147.0	146.95	146.95	14400.0
2007-11-29 18:30:00	SPY	ETF	146.93	147.06	146.81	147.06	23600.0
2007-11-29 19:00:00	SPY	ETF	147.04	147.42	146.99	147.42	79500.0
2007-11-29 19:30:00	SPY	ETF	147.43	148.2	147.43	148.04	129500.0
2007-11-29 06:30:00	QQQ	ETF	51.36	51.43	51.35	51.4	104600.0
2007-11-29 07:00:00	QQQ	ETF	51.33	51.33	51.28	51.32	19837.0
2007-11-29 07:30:00	QQQ	ETF	51.31	51.46	51.3	51.38	127762.0
2007-11-29 08:00:00	QQQ	ETF	51.39	51.54	51.31	51.33	708739.0
2007-11-29 08:30:00	QQQ	ETF	51.33	51.43	51.2	51.35	791217.0
2007-11-29 09:00:00	QQQ	ETF	51.35	51.36	51.27	51.27	809512.0
2007-11-29 09:30:00	QQQ	ETF	51.27	51.7	51.2	51.38	26571628.0
2007-11-29 10:00:00	QQQ	ETF	51.38	51.47	51.22	51.36	14006131.0
2007-11-29 10:30:00	QQQ	ETF	51.365	51.51	51.3	51.47	10250656.0
2007-11-29 11:00:00	QQQ	ETF	51.46	51.68	51.43	51.66	10437161.0
2007-11-29 11:30:00	QQQ	ETF	51.66	51.78	51.63	51.67	13385273.0
2007-11-29 12:00:00	QQQ	ETF	51.67	51.7299	51.5	51.642	6258879.0
2007-11-29 12:30:00	QQQ	ETF	51.65	51.69	51.43	51.45	9697457.0
2007-11-29 13:00:00	QQQ	ETF	51.45	51.53	51.33	51.37	9320628.0
2007-11-29 13:30:00	QQQ	ETF	51.37	51.56	51.23	51.5	14689577.0
2007-11-29 14:00:00	QQQ	ETF	51.5	51.72	51.45	51.69	15217280.0
2007-11-29 14:30:00	QQQ	ETF	51.6884	51.75	51.57	51.74	10909287.0
2007-11-29 15:00:00	QQQ	ETF	51.74	51.89	51.64	51.71	11678622.0
2007-11-29 15:30:00	QQQ	ETF	51.71	51.77	51.56	51.73	9991555.0

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

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