PREVIEW / etf_30min / 2008-03-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-19.parquet
  size:    166 KB
  rows:    5,864

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-03-19 04:30:00	SPY	ETF	132.65	132.7	132.44	132.7	6500.0
2008-03-19 05:00:00	SPY	ETF	132.61	132.61	132.61	132.61	100.0
2008-03-19 05:30:00	SPY	ETF	132.9	132.9	132.7	132.7	800.0
2008-03-19 06:00:00	SPY	ETF	132.65	132.75	132.56	132.64	48100.0
2008-03-19 06:30:00	SPY	ETF	132.85	132.96	132.71	132.8	25800.0
2008-03-19 07:00:00	SPY	ETF	132.76	133.1	132.4	133.1	1422600.0
2008-03-19 07:30:00	SPY	ETF	133.1	133.44	133.04	133.06	1204500.0
2008-03-19 08:00:00	SPY	ETF	133.06	133.15	132.88	133.15	2944460.0
2008-03-19 08:30:00	SPY	ETF	133.12	133.67	132.95	133.6	3634900.0
2008-03-19 09:00:00	SPY	ETF	133.61	134.55	133.59	134.14	9064783.0
2008-03-19 09:30:00	SPY	ETF	134.14	134.65	133.68	133.76	35039582.0
2008-03-19 10:00:00	SPY	ETF	133.76	134.15	133.54	133.61	23349358.0
2008-03-19 10:30:00	SPY	ETF	133.61	134.21	133.01	133.46	30351631.0
2008-03-19 11:00:00	SPY	ETF	133.46	134.15	133.35	134.06	12820754.0
2008-03-19 11:30:00	SPY	ETF	134.06	134.19	133.35	133.77	10012154.0
2008-03-19 12:00:00	SPY	ETF	133.78	134.08	133.09	133.22	14678775.0
2008-03-19 12:30:00	SPY	ETF	133.22	133.31	132.0	132.78	23963878.0
2008-03-19 13:00:00	SPY	ETF	132.79	133.17	132.41	132.51	20505475.0
2008-03-19 13:30:00	SPY	ETF	132.5	134.35	131.58	131.95	25302537.0
2008-03-19 14:00:00	SPY	ETF	131.95	134.48	131.42	131.81	26313506.0
2008-03-19 14:30:00	SPY	ETF	131.81	134.22	131.02	131.99	26006882.0
2008-03-19 15:00:00	SPY	ETF	131.99	132.41	131.1	131.22	23065785.0
2008-03-19 15:30:00	SPY	ETF	131.21	132.0	130.24	130.36	39173264.0
2008-03-19 16:00:00	SPY	ETF	130.28	133.4	130.02	130.27	8525900.0
2008-03-19 16:30:00	SPY	ETF	130.32	132.406	130.0	130.07	1110800.0
2008-03-19 17:00:00	SPY	ETF	130.07	130.24	130.07	130.1	338700.0
2008-03-19 17:30:00	SPY	ETF	130.11	133.5106	130.07	130.22	1904200.0
2008-03-19 18:00:00	SPY	ETF	130.13	130.589	130.02	130.1	270000.0
2008-03-19 18:30:00	SPY	ETF	130.1	130.2	129.9	129.92	44300.0
2008-03-19 19:00:00	SPY	ETF	129.9	130.09	129.75	129.79	48200.0
2008-03-19 19:30:00	SPY	ETF	129.8	129.81	129.65	129.76	63300.0
2008-03-19 20:00:00	SPY	ETF	129.76	129.76	129.76	129.76	800.0
2008-03-19 04:00:00	QQQ	ETF	43.3	43.3	43.3	43.3	1600.0
2008-03-19 05:30:00	QQQ	ETF	43.08	43.08	43.08	43.08	100.0
2008-03-19 06:00:00	QQQ	ETF	43.11	43.11	43.06	43.1	6200.0
2008-03-19 06:30:00	QQQ	ETF	43.14	43.2	43.14	43.2	1038.0
2008-03-19 07:00:00	QQQ	ETF	43.2	43.22	43.08	43.22	51176.0
2008-03-19 07:30:00	QQQ	ETF	43.23	43.3	43.17	43.19	231090.0
2008-03-19 08:00:00	QQQ	ETF	43.18	43.24	43.14	43.17	1172294.0
2008-03-19 08:30:00	QQQ	ETF	43.18	43.36	43.15	43.34	1047857.0
2008-03-19 09:00:00	QQQ	ETF	43.34	43.7	43.15	43.52	2303599.0
2008-03-19 09:30:00	QQQ	ETF	43.52	43.6	43.31	43.36	22107398.0
2008-03-19 10:00:00	QQQ	ETF	43.355	43.5	43.29	43.32	15008438.0
2008-03-19 10:30:00	QQQ	ETF	43.32	43.32	42.98	43.2199	22158326.0
2008-03-19 11:00:00	QQQ	ETF	43.22	43.54	43.17	43.5	14978060.0
2008-03-19 11:30:00	QQQ	ETF	43.5	43.55	43.35	43.35	8119950.0
2008-03-19 12:00:00	QQQ	ETF	43.3599	43.41	43.18	43.21	11634090.0
2008-03-19 12:30:00	QQQ	ETF	43.22	43.25	42.99	43.08	9389766.0
2008-03-19 13:00:00	QQQ	ETF	43.09	43.2	42.97	43.05	10526898.0
2008-03-19 13:30:00	QQQ	ETF	43.04	43.08	42.81	42.87	15420531.0

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

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