PREVIEW / etf_30min / 2007-04-25

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-25.parquet
  size:    112 KB
  rows:    3,875

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-04-25 04:00:00	SPY	ETF	148.25	148.56	148.25	148.55	24000.0
2007-04-25 04:30:00	SPY	ETF	148.5	148.5	148.5	148.5	500.0
2007-04-25 06:00:00	SPY	ETF	148.58	148.59	148.52	148.52	10000.0
2007-04-25 07:00:00	SPY	ETF	148.51	148.58	148.48	148.54	206700.0
2007-04-25 07:30:00	SPY	ETF	148.56	148.57	148.47	148.47	283600.0
2007-04-25 08:00:00	SPY	ETF	148.53	148.56	148.45	148.51	1412800.0
2007-04-25 08:30:00	SPY	ETF	148.5	148.84	148.5	148.77	2684900.0
2007-04-25 09:00:00	SPY	ETF	148.77	148.81	148.71	148.74	724700.0
2007-04-25 09:30:00	SPY	ETF	148.73	148.97	148.5	148.55	13494098.0
2007-04-25 10:00:00	SPY	ETF	148.55	148.64	148.16	148.39	15397450.0
2007-04-25 10:30:00	SPY	ETF	148.39	148.54	148.32	148.37	7445557.0
2007-04-25 11:00:00	SPY	ETF	148.38	148.67	148.38	148.57	5248307.0
2007-04-25 11:30:00	SPY	ETF	148.57	148.92	148.49	148.88	6006066.0
2007-04-25 12:00:00	SPY	ETF	148.88	148.9	148.72	148.79	3333103.0
2007-04-25 12:30:00	SPY	ETF	148.79	148.82	148.71	148.8	1778703.0
2007-04-25 13:00:00	SPY	ETF	148.8	149.01	148.77	148.89	6336087.0
2007-04-25 13:30:00	SPY	ETF	148.89	149.11	148.815	149.0585	4922541.0
2007-04-25 14:00:00	SPY	ETF	149.04	149.22	148.98	149.18	5351719.0
2007-04-25 14:30:00	SPY	ETF	149.18	149.4	149.18	149.33	7284338.0
2007-04-25 15:00:00	SPY	ETF	149.33	149.58	149.33	149.56	8335824.0
2007-04-25 15:30:00	SPY	ETF	149.56	149.66	148.97	149.46	12555041.0
2007-04-25 16:00:00	SPY	ETF	149.46	149.53	148.56	149.47	1308200.0
2007-04-25 16:30:00	SPY	ETF	149.43	149.58	149.42	149.56	1314800.0
2007-04-25 17:00:00	SPY	ETF	149.56	149.57	149.43	149.48	746200.0
2007-04-25 17:30:00	SPY	ETF	149.47	149.54	149.41	149.52	19800.0
2007-04-25 18:00:00	SPY	ETF	149.53	149.58	149.53	149.54	11000.0
2007-04-25 18:30:00	SPY	ETF	149.56	149.56	149.51	149.52	700.0
2007-04-25 19:00:00	SPY	ETF	149.52	149.54	149.51	149.54	2600.0
2007-04-25 19:30:00	SPY	ETF	149.56	149.57	149.53	149.57	10000.0
2007-04-25 04:00:00	QQQ	ETF	45.69	45.84	45.69	45.82	102500.0
2007-04-25 04:30:00	QQQ	ETF	45.83	45.83	45.83	45.83	500.0
2007-04-25 05:00:00	QQQ	ETF	45.84	45.84	45.84	45.84	500.0
2007-04-25 07:00:00	QQQ	ETF	45.81	45.86	45.79	45.86	497407.0
2007-04-25 07:30:00	QQQ	ETF	45.84	45.84	45.8	45.8	255903.0
2007-04-25 08:00:00	QQQ	ETF	45.82	45.83	45.79	45.81	808660.0
2007-04-25 08:30:00	QQQ	ETF	45.85	45.92	45.85	45.89	1669364.0
2007-04-25 09:00:00	QQQ	ETF	45.89	45.891	45.85	45.85	1716572.0
2007-04-25 09:30:00	QQQ	ETF	45.84	45.89	45.78	45.83	12675700.0
2007-04-25 10:00:00	QQQ	ETF	45.83	45.87	45.7	45.82	12444900.0
2007-04-25 10:30:00	QQQ	ETF	45.82	45.87	45.79	45.79	6062100.0
2007-04-25 11:00:00	QQQ	ETF	45.8	45.9	45.79	45.87	3956400.0
2007-04-25 11:30:00	QQQ	ETF	45.86	46.04	45.86	46.03	9998800.0
2007-04-25 12:00:00	QQQ	ETF	46.03	46.04	45.98	46.02	4702200.0
2007-04-25 12:30:00	QQQ	ETF	46.02	46.05	45.98	46.03	4029500.0
2007-04-25 13:00:00	QQQ	ETF	46.02	46.13	46.02	46.1	4543300.0
2007-04-25 13:30:00	QQQ	ETF	46.11	46.22	46.07	46.21	5572700.0
2007-04-25 14:00:00	QQQ	ETF	46.21	46.26	46.16	46.2	6830700.0
2007-04-25 14:30:00	QQQ	ETF	46.21	46.29	46.2	46.26	5458400.0
2007-04-25 15:00:00	QQQ	ETF	46.26	46.32	46.18	46.25	8175800.0
2007-04-25 15:30:00	QQQ	ETF	46.26	46.28	46.2	46.27	8911000.0

> showing 50 of 3,875 rows — these rows as CSV

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