PREVIEW / etf_30min / 2004-07-01

all etf 30-min files

  file:    by_date/etf_30min/2004/2004-07-01.parquet
  size:    37 KB
  rows:    1,191

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
2004-07-01 08:00:00	SPY	ETF	114.51	114.51	114.34	114.36	21300.0
2004-07-01 08:30:00	SPY	ETF	114.37	114.4	114.3	114.39	32200.0
2004-07-01 09:00:00	SPY	ETF	114.39	114.47	114.3	114.3	62300.0
2004-07-01 09:30:00	SPY	ETF	114.25	114.4	114.04	114.09	4130200.0
2004-07-01 10:00:00	SPY	ETF	114.09	114.28	113.82	113.92	3819300.0
2004-07-01 10:30:00	SPY	ETF	113.92	113.97	113.53	113.55	2757000.0
2004-07-01 11:00:00	SPY	ETF	113.53	113.57	112.85	113.18	9524700.0
2004-07-01 11:30:00	SPY	ETF	113.18	113.19	112.98	113.09	2835700.0
2004-07-01 12:00:00	SPY	ETF	113.08	113.12	112.91	113.1	2233400.0
2004-07-01 12:30:00	SPY	ETF	113.15	113.23	113.02	113.19	1760400.0
2004-07-01 13:00:00	SPY	ETF	113.18	113.23	112.88	112.95	1967800.0
2004-07-01 13:30:00	SPY	ETF	112.94	113.09	112.58	112.76	4547500.0
2004-07-01 14:00:00	SPY	ETF	112.77	113.01	112.71	112.99	3317400.0
2004-07-01 14:30:00	SPY	ETF	113.0	113.16	112.79	113.08	3213700.0
2004-07-01 15:00:00	SPY	ETF	113.09	113.24	112.91	113.01	2966200.0
2004-07-01 15:30:00	SPY	ETF	113.03	113.4	113.01	113.2	7092300.0
2004-07-01 16:00:00	SPY	ETF	113.19	113.59	112.9	113.59	2011700.0
2004-07-01 16:30:00	SPY	ETF	113.58	113.58	112.98	113.06	448000.0
2004-07-01 17:00:00	SPY	ETF	113.0	113.0	112.95	112.97	3400.0
2004-07-01 17:30:00	SPY	ETF	113.0	113.0	112.97	113.0	10200.0
2004-07-01 18:00:00	SPY	ETF	112.97	113.01	112.93	113.01	33000.0
2004-07-01 18:30:00	SPY	ETF	112.98	112.98	112.98	112.98	1900.0
2004-07-01 08:00:00	QQQ	ETF	37.76	37.76	37.64	37.65	54600.0
2004-07-01 08:30:00	QQQ	ETF	37.66	37.66	37.62	37.64	104100.0
2004-07-01 09:00:00	QQQ	ETF	37.64	37.67	37.63	37.66	131300.0
2004-07-01 09:30:00	QQQ	ETF	37.66	37.66	37.43	37.483	9349900.0
2004-07-01 10:00:00	QQQ	ETF	37.48	37.531	37.31	37.36	12604300.0
2004-07-01 10:30:00	QQQ	ETF	37.37	37.4	37.19	37.2	8966900.0
2004-07-01 11:00:00	QQQ	ETF	37.2	37.22	36.98	37.12	15955500.0
2004-07-01 11:30:00	QQQ	ETF	37.12	37.13	37.0	37.021	7381800.0
2004-07-01 12:00:00	QQQ	ETF	37.02	37.05	36.94	37.025	7448100.0
2004-07-01 12:30:00	QQQ	ETF	37.025	37.1	37.02	37.08	4853000.0
2004-07-01 13:00:00	QQQ	ETF	37.09	37.09	36.92	36.94	5767100.0
2004-07-01 13:30:00	QQQ	ETF	36.95	36.99	36.77	36.88	8056400.0
2004-07-01 14:00:00	QQQ	ETF	36.881	37.01	36.86	36.99	7865700.0
2004-07-01 14:30:00	QQQ	ETF	36.99	37.054	36.92	37.025	5817000.0
2004-07-01 15:00:00	QQQ	ETF	37.02	37.09	36.9	36.987	6900200.0
2004-07-01 15:30:00	QQQ	ETF	36.99	37.12	36.99	37.04	10652500.0
2004-07-01 16:00:00	QQQ	ETF	37.06	37.105	37.0	37.04	2513400.0
2004-07-01 16:30:00	QQQ	ETF	37.02	37.043	37.01	37.04	78700.0
2004-07-01 17:00:00	QQQ	ETF	37.04	37.043	37.01	37.03	32900.0
2004-07-01 17:30:00	QQQ	ETF	37.01	37.04	37.01	37.02	12900.0
2004-07-01 18:00:00	QQQ	ETF	37.04	37.05	37.04	37.05	23700.0
2004-07-01 19:00:00	QQQ	ETF	37.04	37.04	37.02	37.02	3500.0
2004-07-01 19:30:00	QQQ	ETF	37.04	37.09	37.04	37.05	7000.0
2004-07-01 08:30:00	IWM	ETF	58.82	58.82	58.81	58.81	3000.0
2004-07-01 09:00:00	IWM	ETF	58.91	58.91	58.895	58.895	5200.0
2004-07-01 09:30:00	IWM	ETF	58.91	59.04	58.7	58.745	1541800.0
2004-07-01 10:00:00	IWM	ETF	58.745	58.76	58.42	58.475	1418200.0
2004-07-01 10:30:00	IWM	ETF	58.47	58.55	58.305	58.315	1317200.0

> showing 50 of 1,191 rows — these rows as CSV

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