PREVIEW / etf_30min / 2007-06-12

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-12.parquet
  size:    120 KB
  rows:    4,432

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-12 06:00:00	SPY	ETF	150.88	151.78	150.88	151.17	12300.0
2007-06-12 06:30:00	SPY	ETF	150.97	151.17	150.97	151.12	22600.0
2007-06-12 07:00:00	SPY	ETF	151.1	151.1	150.74	150.77	649000.0
2007-06-12 07:30:00	SPY	ETF	150.77	151.0	150.77	150.95	315000.0
2007-06-12 08:00:00	SPY	ETF	150.98	151.17	150.79	150.91	2793200.0
2007-06-12 08:30:00	SPY	ETF	150.9	150.97	150.7	150.74	1623600.0
2007-06-12 09:00:00	SPY	ETF	150.73	150.81	150.64	150.67	2462200.0
2007-06-12 09:30:00	SPY	ETF	150.67	151.02	150.56	150.65	11836320.0
2007-06-12 10:00:00	SPY	ETF	150.65	150.76	150.13	150.16	18215160.0
2007-06-12 10:30:00	SPY	ETF	150.165	150.44	150.16	150.28	13555299.0
2007-06-12 11:00:00	SPY	ETF	150.28	150.6	150.07	150.48	12134811.0
2007-06-12 11:30:00	SPY	ETF	150.48	150.96	150.45	150.85	13316478.0
2007-06-12 12:00:00	SPY	ETF	150.85	150.85	150.62	150.67	5038605.0
2007-06-12 12:30:00	SPY	ETF	150.67	150.68	150.525	150.57	4727600.0
2007-06-12 13:00:00	SPY	ETF	150.56	150.94	150.42	150.76	12110636.0
2007-06-12 13:30:00	SPY	ETF	150.75	151.31	150.69	151.27	13865922.0
2007-06-12 14:00:00	SPY	ETF	151.27	151.54	150.91	150.99	16605520.0
2007-06-12 14:30:00	SPY	ETF	150.9901	151.27	150.34	150.71	22961464.0
2007-06-12 15:00:00	SPY	ETF	150.71	151.26	149.82	150.14	36645041.0
2007-06-12 15:30:00	SPY	ETF	150.14	150.23	149.67	149.67	22352620.0
2007-06-12 16:00:00	SPY	ETF	149.69	149.85	149.54	149.65	16628000.0
2007-06-12 16:30:00	SPY	ETF	149.65	149.66	149.36	149.4	805500.0
2007-06-12 17:00:00	SPY	ETF	149.41	149.47	149.38	149.39	147600.0
2007-06-12 17:30:00	SPY	ETF	149.44	149.48	149.38	149.4	1770800.0
2007-06-12 18:00:00	SPY	ETF	149.4	149.43	149.35	149.43	36900.0
2007-06-12 18:30:00	SPY	ETF	149.43	149.52	149.43	149.47	3000.0
2007-06-12 19:00:00	SPY	ETF	149.48	149.48	149.38	149.38	2600.0
2007-06-12 19:30:00	SPY	ETF	149.38	149.4	149.29	149.29	37300.0
2007-06-12 04:00:00	QQQ	ETF	46.82	46.82	46.82	46.82	100.0
2007-06-12 04:30:00	QQQ	ETF	46.82	46.87	46.82	46.87	600.0
2007-06-12 06:00:00	QQQ	ETF	46.77	46.77	46.77	46.77	200.0
2007-06-12 06:30:00	QQQ	ETF	46.75	46.8	46.75	46.78	17000.0
2007-06-12 07:00:00	QQQ	ETF	46.76	46.76	46.59	46.59	472139.0
2007-06-12 07:30:00	QQQ	ETF	46.58	46.69	46.57	46.63	246490.0
2007-06-12 08:00:00	QQQ	ETF	46.65	46.73	46.65	46.66	903332.0
2007-06-12 08:30:00	QQQ	ETF	46.66	46.68	46.6	46.6	424789.0
2007-06-12 09:00:00	QQQ	ETF	46.61	46.65	46.56	46.57	725366.0
2007-06-12 09:30:00	QQQ	ETF	46.57	46.74	46.5	46.58	12051375.0
2007-06-12 10:00:00	QQQ	ETF	46.59	46.7	46.47	46.51	13537921.0
2007-06-12 10:30:00	QQQ	ETF	46.5	46.59	46.49	46.555	8253771.0
2007-06-12 11:00:00	QQQ	ETF	46.54	46.64	46.45	46.59	8719567.0
2007-06-12 11:30:00	QQQ	ETF	46.59	46.77	46.55	46.76	13939504.0
2007-06-12 12:00:00	QQQ	ETF	46.7515	46.8	46.69	46.72	5568909.0
2007-06-12 12:30:00	QQQ	ETF	46.72	46.72	46.63	46.65	4362855.0
2007-06-12 13:00:00	QQQ	ETF	46.65	46.77	46.6	46.75	12069426.0
2007-06-12 13:30:00	QQQ	ETF	46.74	46.96	46.6899	46.95	15961207.0
2007-06-12 14:00:00	QQQ	ETF	46.95	47.04	46.83	46.85	9160877.0
2007-06-12 14:30:00	QQQ	ETF	46.85	46.9	46.7	46.81	10283307.0
2007-06-12 15:00:00	QQQ	ETF	46.82	46.86	46.52	46.61	17452686.0
2007-06-12 15:30:00	QQQ	ETF	46.61	46.63	46.49	46.55	13644802.0

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

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