PREVIEW / etf_30min / 2007-06-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-05.parquet
  size:    116 KB
  rows:    4,401

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-06-05 05:30:00	SPY	ETF	154.19	154.19	154.19	154.19	1000.0
2007-06-05 06:00:00	SPY	ETF	154.18	154.18	154.06	154.06	20000.0
2007-06-05 06:30:00	SPY	ETF	154.07	154.07	154.01	154.01	10000.0
2007-06-05 07:00:00	SPY	ETF	154.0	154.0	153.84	153.84	172300.0
2007-06-05 07:30:00	SPY	ETF	153.86	153.9	153.81	153.85	36000.0
2007-06-05 08:00:00	SPY	ETF	153.96	153.96	153.7	153.72	702200.0
2007-06-05 08:30:00	SPY	ETF	153.73	153.75	153.63	153.72	3937200.0
2007-06-05 09:00:00	SPY	ETF	153.7	153.76	153.66	153.74	818100.0
2007-06-05 09:30:00	SPY	ETF	153.72	153.84	153.51	153.64	10295040.0
2007-06-05 10:00:00	SPY	ETF	153.63	153.85	153.32	153.54	21675429.0
2007-06-05 10:30:00	SPY	ETF	153.54	153.9	153.36	153.8	8310589.0
2007-06-05 11:00:00	SPY	ETF	153.8	153.89	153.66	153.72	5731562.0
2007-06-05 11:30:00	SPY	ETF	153.71	153.71	153.22	153.23	7431800.0
2007-06-05 12:00:00	SPY	ETF	153.23	153.5	152.86	152.96	12028733.0
2007-06-05 12:30:00	SPY	ETF	152.96	153.28	152.96	153.23	8371100.0
2007-06-05 13:00:00	SPY	ETF	153.23	153.39	153.09	153.12	4749034.0
2007-06-05 13:30:00	SPY	ETF	153.11	153.34	153.04	153.26	6026720.0
2007-06-05 14:00:00	SPY	ETF	153.27	153.43	153.15	153.29	5869207.0
2007-06-05 14:30:00	SPY	ETF	153.29	153.32	153.08	153.16	4506753.0
2007-06-05 15:00:00	SPY	ETF	153.17	153.63	153.12	153.41	9914314.0
2007-06-05 15:30:00	SPY	ETF	153.41	153.57	153.39	153.445	9691972.0
2007-06-05 16:00:00	SPY	ETF	153.45	153.55	153.37	153.47	2042300.0
2007-06-05 16:30:00	SPY	ETF	153.49	153.53	153.47	153.53	163800.0
2007-06-05 17:00:00	SPY	ETF	153.52	153.55	153.08	153.53	130000.0
2007-06-05 17:30:00	SPY	ETF	153.53	153.53	153.46	153.51	932500.0
2007-06-05 18:00:00	SPY	ETF	153.51	153.56	153.51	153.56	3400.0
2007-06-05 18:30:00	SPY	ETF	153.54	153.54	153.54	153.54	100.0
2007-06-05 19:00:00	SPY	ETF	153.55	153.55	153.54	153.55	20100.0
2007-06-05 19:30:00	SPY	ETF	153.53	153.53	153.47	153.47	3500.0
2007-06-05 06:30:00	QQQ	ETF	47.53	47.53	47.53	47.53	150.0
2007-06-05 07:00:00	QQQ	ETF	47.5	47.5	47.45	47.45	38000.0
2007-06-05 07:30:00	QQQ	ETF	47.45	47.47	47.42	47.46	123071.0
2007-06-05 08:00:00	QQQ	ETF	47.46	47.48	47.43	47.43	335402.0
2007-06-05 08:30:00	QQQ	ETF	47.42	47.45	47.41	47.44	565819.0
2007-06-05 09:00:00	QQQ	ETF	47.44	47.45	47.41	47.44	438429.0
2007-06-05 09:30:00	QQQ	ETF	47.43	47.5	47.34	47.43	10119334.0
2007-06-05 10:00:00	QQQ	ETF	47.43	47.5	47.29	47.41	12813495.0
2007-06-05 10:30:00	QQQ	ETF	47.41	47.52	47.33	47.47	6341036.0
2007-06-05 11:00:00	QQQ	ETF	47.48	47.53	47.41	47.45	16166397.0
2007-06-05 11:30:00	QQQ	ETF	47.44	47.49	47.27	47.27	13069675.0
2007-06-05 12:00:00	QQQ	ETF	47.26	47.32	47.14	47.18	18897399.0
2007-06-05 12:30:00	QQQ	ETF	47.18	47.32	47.0	47.31	18964273.0
2007-06-05 13:00:00	QQQ	ETF	47.31	47.41	47.24	47.32	14739416.0
2007-06-05 13:30:00	QQQ	ETF	47.32	47.38	47.27	47.36	6457040.0
2007-06-05 14:00:00	QQQ	ETF	47.35	47.44	47.32	47.3895	5555447.0
2007-06-05 14:30:00	QQQ	ETF	47.39	47.4	47.28	47.342	4575748.0
2007-06-05 15:00:00	QQQ	ETF	47.3415	47.46	47.33	47.45	5116708.0
2007-06-05 15:30:00	QQQ	ETF	47.46	47.58	47.45	47.575	10981456.0
2007-06-05 16:00:00	QQQ	ETF	47.57	47.61	47.51	47.57	2718106.0
2007-06-05 16:30:00	QQQ	ETF	47.57	47.58	47.54	47.57	172877.0

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

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