PREVIEW / etf_30min / 2007-05-15

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-15.parquet
  size:    114 KB
  rows:    4,025

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-05-15 05:00:00	SPY	ETF	150.28	150.3	150.28	150.3	20000.0
2007-05-15 05:30:00	SPY	ETF	150.39	150.39	150.39	150.39	10000.0
2007-05-15 06:00:00	SPY	ETF	150.33	150.33	150.14	150.14	7500.0
2007-05-15 06:30:00	SPY	ETF	150.12	150.12	150.12	150.12	3000.0
2007-05-15 07:00:00	SPY	ETF	150.05	150.13	150.05	150.09	247100.0
2007-05-15 07:30:00	SPY	ETF	150.08	150.21	150.06	150.19	258500.0
2007-05-15 08:00:00	SPY	ETF	150.19	150.2	150.06	150.06	912500.0
2007-05-15 08:30:00	SPY	ETF	150.25	150.9	150.16	150.73	6654800.0
2007-05-15 09:00:00	SPY	ETF	150.73	150.75	150.05	150.71	657700.0
2007-05-15 09:30:00	SPY	ETF	150.7	150.98	150.45	150.76	17658618.0
2007-05-15 10:00:00	SPY	ETF	150.76	151.57	150.74	151.4	26513263.0
2007-05-15 10:30:00	SPY	ETF	151.4	151.41	151.03	151.1	11087750.0
2007-05-15 11:00:00	SPY	ETF	151.1	151.355	150.89	151.16	8547550.0
2007-05-15 11:30:00	SPY	ETF	151.15	151.56	151.12	151.39	10803800.0
2007-05-15 12:00:00	SPY	ETF	151.39	151.55	151.32	151.45	4743951.0
2007-05-15 12:30:00	SPY	ETF	151.45	151.665	151.28	151.32	10057100.0
2007-05-15 13:00:00	SPY	ETF	151.32	151.435	151.17	151.35	7184600.0
2007-05-15 13:30:00	SPY	ETF	151.34	151.4	150.84	151.07	17578621.0
2007-05-15 14:00:00	SPY	ETF	151.07	151.15	150.75	150.84	8054750.0
2007-05-15 14:30:00	SPY	ETF	150.83	150.95	150.22	150.56	18610250.0
2007-05-15 15:00:00	SPY	ETF	150.55	150.66	150.33	150.52	13242000.0
2007-05-15 15:30:00	SPY	ETF	150.52	150.68	150.19	150.38	10587955.0
2007-05-15 16:00:00	SPY	ETF	150.38	150.57	150.38	150.48	5527200.0
2007-05-15 16:30:00	SPY	ETF	150.47	150.48	150.4	150.4	894400.0
2007-05-15 17:00:00	SPY	ETF	150.42	150.5	150.42	150.48	213700.0
2007-05-15 17:30:00	SPY	ETF	150.46	150.53	150.41	150.53	38100.0
2007-05-15 18:00:00	SPY	ETF	150.53	150.56	150.46	150.53	208400.0
2007-05-15 18:30:00	SPY	ETF	150.5	150.53	150.5	150.52	23800.0
2007-05-15 19:00:00	SPY	ETF	150.5	150.53	150.5	150.5	11700.0
2007-05-15 19:30:00	SPY	ETF	150.45	150.49	150.45	150.45	2400.0
2007-05-15 05:30:00	QQQ	ETF	46.39	46.39	46.38	46.38	15000.0
2007-05-15 06:00:00	QQQ	ETF	46.36	46.36	46.36	46.36	200.0
2007-05-15 07:00:00	QQQ	ETF	46.27	46.29	46.27	46.28	121200.0
2007-05-15 07:30:00	QQQ	ETF	46.27	46.29	46.26	46.28	128366.0
2007-05-15 08:00:00	QQQ	ETF	46.3	46.31	46.25	46.28	414434.0
2007-05-15 08:30:00	QQQ	ETF	46.31	46.53	46.25	46.43	2791994.0
2007-05-15 09:00:00	QQQ	ETF	46.43	46.46	46.41	46.41	1773928.0
2007-05-15 09:30:00	QQQ	ETF	46.41	46.5	46.23	46.3978	20464449.0
2007-05-15 10:00:00	QQQ	ETF	46.39	46.7	46.38	46.64	23483538.0
2007-05-15 10:30:00	QQQ	ETF	46.64	46.66	46.46	46.5	16250163.0
2007-05-15 11:00:00	QQQ	ETF	46.5	46.54	46.42	46.52	10369046.0
2007-05-15 11:30:00	QQQ	ETF	46.51	46.65	46.48	46.56	6627043.0
2007-05-15 12:00:00	QQQ	ETF	46.57	46.64	46.55	46.593	6264119.0
2007-05-15 12:30:00	QQQ	ETF	46.6	46.68	46.48	46.48	5906802.0
2007-05-15 13:00:00	QQQ	ETF	46.48	46.55	46.42	46.51	6490001.0
2007-05-15 13:30:00	QQQ	ETF	46.51	46.53	46.26	46.37	15536599.0
2007-05-15 14:00:00	QQQ	ETF	46.37	46.4	46.2	46.21	11634581.0
2007-05-15 14:30:00	QQQ	ETF	46.22	46.28	46.01	46.18	15970659.0
2007-05-15 15:00:00	QQQ	ETF	46.17	46.21	46.06	46.13	10914584.0
2007-05-15 15:30:00	QQQ	ETF	46.14	46.2	45.99	46.04	15349874.0

> showing 50 of 4,025 rows — these rows as CSV

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