PREVIEW / etf_30min / 2008-04-22

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-22.parquet
  size:    161 KB
  rows:    5,638

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
2008-04-22 04:30:00	SPY	ETF	138.29	138.29	138.29	138.29	100.0
2008-04-22 05:30:00	SPY	ETF	138.47	138.62	138.47	138.62	100100.0
2008-04-22 06:00:00	SPY	ETF	138.7	138.75	138.5	138.5	257000.0
2008-04-22 06:30:00	SPY	ETF	138.52	138.55	138.42	138.47	16000.0
2008-04-22 07:00:00	SPY	ETF	138.44	138.67	138.4	138.54	188000.0
2008-04-22 07:30:00	SPY	ETF	138.5	138.68	138.42	138.48	297951.0
2008-04-22 08:00:00	SPY	ETF	138.51	138.63	138.34	138.42	761036.0
2008-04-22 08:30:00	SPY	ETF	138.45	138.45	138.0	138.33	104004.0
2008-04-22 09:00:00	SPY	ETF	138.34	138.37	138.13	138.18	1099047.0
2008-04-22 09:30:00	SPY	ETF	138.19	138.24	137.7	137.87	15199740.0
2008-04-22 10:00:00	SPY	ETF	137.86	138.31	137.66	137.67	15560436.0
2008-04-22 10:30:00	SPY	ETF	137.67	138.07	137.59	138.06	9200574.0
2008-04-22 11:00:00	SPY	ETF	138.07	138.14	136.64	137.92	9639236.0
2008-04-22 11:30:00	SPY	ETF	137.93	138.14	137.0	137.5012	12215696.0
2008-04-22 12:00:00	SPY	ETF	137.5	137.58	137.26	137.3	10309606.0
2008-04-22 12:30:00	SPY	ETF	137.3	137.34	136.93	137.01	12724224.0
2008-04-22 13:00:00	SPY	ETF	137.0011	138.37	136.92	137.25	9856879.0
2008-04-22 13:30:00	SPY	ETF	137.25	137.47	137.15	137.41	7665991.0
2008-04-22 14:00:00	SPY	ETF	137.41	137.49	137.18	137.4	8093024.0
2008-04-22 14:30:00	SPY	ETF	137.4	137.55	136.9	137.1	12897516.0
2008-04-22 15:00:00	SPY	ETF	137.11	137.5	137.01	137.39	11322158.0
2008-04-22 15:30:00	SPY	ETF	137.4	137.69	137.24	137.69	12484793.0
2008-04-22 16:00:00	SPY	ETF	137.7	137.97	137.46	137.81	7911078.0
2008-04-22 16:30:00	SPY	ETF	137.8	138.05	137.74	138.0	749367.0
2008-04-22 17:00:00	SPY	ETF	138.0	138.09	137.96	138.08	315820.0
2008-04-22 17:30:00	SPY	ETF	138.09	138.19	138.03	138.1	87310.0
2008-04-22 18:00:00	SPY	ETF	138.1	138.1	137.9	137.92	151547.0
2008-04-22 18:30:00	SPY	ETF	137.91	137.95	137.91	137.95	6048.0
2008-04-22 19:00:00	SPY	ETF	137.91	138.05	137.91	137.98	20202.0
2008-04-22 19:30:00	SPY	ETF	137.97	138.01	137.95	137.98	3200.0
2008-04-22 04:00:00	QQQ	ETF	46.75	46.75	46.75	46.75	100.0
2008-04-22 06:30:00	QQQ	ETF	46.78	46.78	46.73	46.73	2800.0
2008-04-22 07:00:00	QQQ	ETF	46.82	46.87	46.82	46.84	26740.0
2008-04-22 07:30:00	QQQ	ETF	46.81	46.86	46.78	46.78	233231.0
2008-04-22 08:00:00	QQQ	ETF	46.8	46.85	46.78	46.79	189900.0
2008-04-22 08:30:00	QQQ	ETF	46.8	46.8	46.65	46.77	159482.0
2008-04-22 09:00:00	QQQ	ETF	46.76	46.77	46.67	46.73	293099.0
2008-04-22 09:30:00	QQQ	ETF	46.73	46.76	46.57	46.62	8709787.0
2008-04-22 10:00:00	QQQ	ETF	46.62	46.77	46.5	46.5	12129759.0
2008-04-22 10:30:00	QQQ	ETF	46.5	46.62	46.48	46.62	6537175.0
2008-04-22 11:00:00	QQQ	ETF	46.63	46.66	46.5	46.5595	6901411.0
2008-04-22 11:30:00	QQQ	ETF	46.55	46.619	46.29	46.3285	7206465.0
2008-04-22 12:00:00	QQQ	ETF	46.32	46.33	46.11	46.11	8274451.0
2008-04-22 12:30:00	QQQ	ETF	46.11	46.1199	45.93	45.98	7480181.0
2008-04-22 13:00:00	QQQ	ETF	45.98	46.13	45.95	46.1199	3589949.0
2008-04-22 13:30:00	QQQ	ETF	46.12	46.25	46.07	46.2278	5409438.0
2008-04-22 14:00:00	QQQ	ETF	46.23	46.24	46.1	46.2199	4321325.0
2008-04-22 14:30:00	QQQ	ETF	46.22	46.281	46.05	46.12	4659976.0
2008-04-22 15:00:00	QQQ	ETF	46.12	46.25	46.09	46.23	7559270.0
2008-04-22 15:30:00	QQQ	ETF	46.23	46.35	46.18	46.33	7585903.0

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

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