PREVIEW / etf_30min / 2007-10-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-30.parquet
  size:    128 KB
  rows:    4,941

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-10-30 06:30:00	SPY	ETF	153.77	153.77	153.56	153.65	137700.0
2007-10-30 07:00:00	SPY	ETF	153.69	153.74	153.6	153.62	144300.0
2007-10-30 07:30:00	SPY	ETF	153.6	153.61	153.45	153.45	172800.0
2007-10-30 08:00:00	SPY	ETF	153.47	153.62	153.45	153.6	1540900.0
2007-10-30 08:30:00	SPY	ETF	153.63	153.73	153.35	153.41	2146700.0
2007-10-30 09:00:00	SPY	ETF	153.4	153.47	153.31	153.42	2098900.0
2007-10-30 09:30:00	SPY	ETF	153.45	153.7	153.43	153.52	9986968.0
2007-10-30 10:00:00	SPY	ETF	153.51	153.57	153.0	153.42	19082994.0
2007-10-30 10:30:00	SPY	ETF	153.41	153.53	153.31	153.48	7560986.0
2007-10-30 11:00:00	SPY	ETF	153.48	153.49	153.1	153.13	10379362.0
2007-10-30 11:30:00	SPY	ETF	153.13	153.25	152.96	153.23	10751730.0
2007-10-30 12:00:00	SPY	ETF	153.23	153.37	153.19	153.25	4820502.0
2007-10-30 12:30:00	SPY	ETF	153.25	153.439	153.14	153.3599	5175430.0
2007-10-30 13:00:00	SPY	ETF	153.36	153.66	153.3	153.53	6493187.0
2007-10-30 13:30:00	SPY	ETF	153.53	153.75	153.44	153.66	6121814.0
2007-10-30 14:00:00	SPY	ETF	153.65	153.75	153.5	153.54	10068079.0
2007-10-30 14:30:00	SPY	ETF	153.53	153.67	153.44	153.55	4664331.0
2007-10-30 15:00:00	SPY	ETF	153.55	153.7	153.37	153.37	5091909.0
2007-10-30 15:30:00	SPY	ETF	153.37	153.46	152.87	153.06	20225918.0
2007-10-30 16:00:00	SPY	ETF	153.05	153.11	152.95	152.98	2238600.0
2007-10-30 16:30:00	SPY	ETF	153.0	153.03	152.86	152.92	175300.0
2007-10-30 17:00:00	SPY	ETF	152.89	152.99	152.86	152.99	41000.0
2007-10-30 17:30:00	SPY	ETF	152.95	152.98	152.95	152.98	1100.0
2007-10-30 18:00:00	SPY	ETF	152.99	152.99	152.92	152.92	10400.0
2007-10-30 18:30:00	SPY	ETF	152.91	152.94	152.87	152.87	19700.0
2007-10-30 19:00:00	SPY	ETF	152.87	152.88	152.87	152.88	1600.0
2007-10-30 19:30:00	SPY	ETF	152.91	152.94	152.9	152.94	4400.0
2007-10-30 05:30:00	QQQ	ETF	54.05	54.05	54.05	54.05	300.0
2007-10-30 07:00:00	QQQ	ETF	53.95	53.96	53.92	53.93	106767.0
2007-10-30 07:30:00	QQQ	ETF	53.93	53.96	53.9	53.91	75352.0
2007-10-30 08:00:00	QQQ	ETF	53.91	53.99	53.91	53.98	183334.0
2007-10-30 08:30:00	QQQ	ETF	53.99	54.04	53.89	53.89	1262780.0
2007-10-30 09:00:00	QQQ	ETF	53.9	53.95	53.86	53.94	1601472.0
2007-10-30 09:30:00	QQQ	ETF	53.93	54.15	53.91	54.08	13076626.0
2007-10-30 10:00:00	QQQ	ETF	54.07	54.15	53.9	54.13	9776536.0
2007-10-30 10:30:00	QQQ	ETF	54.12	54.25	54.09	54.22	5875909.0
2007-10-30 11:00:00	QQQ	ETF	54.22	54.22	54.06	54.07	6037977.0
2007-10-30 11:30:00	QQQ	ETF	54.06	54.15	54.04	54.128	5099122.0
2007-10-30 12:00:00	QQQ	ETF	54.12	54.17	54.08	54.1372	3139290.0
2007-10-30 12:30:00	QQQ	ETF	54.14	54.24	54.1	54.21	4667007.0
2007-10-30 13:00:00	QQQ	ETF	54.21	54.34	54.17	54.34	5301370.0
2007-10-30 13:30:00	QQQ	ETF	54.33	54.45	54.33	54.36	6812812.0
2007-10-30 14:00:00	QQQ	ETF	54.37	54.47	54.33	54.4	4170421.0
2007-10-30 14:30:00	QQQ	ETF	54.408	54.47	54.35	54.4	3553574.0
2007-10-30 15:00:00	QQQ	ETF	54.4	54.56	54.38	54.43	13149540.0
2007-10-30 15:30:00	QQQ	ETF	54.43	54.49	54.21	54.26	22025203.0
2007-10-30 16:00:00	QQQ	ETF	54.26	54.36	54.1642	54.21	5669315.0
2007-10-30 16:30:00	QQQ	ETF	54.2	54.26	54.15	54.26	2974766.0
2007-10-30 17:00:00	QQQ	ETF	54.19	54.26	54.18	54.21	54701.0
2007-10-30 17:30:00	QQQ	ETF	54.22	54.26	54.21	54.23	3139.0

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

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