PREVIEW / etf_30min / 2007-11-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-06.parquet
  size:    137 KB
  rows:    5,076

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-11-06 05:30:00	SPY	ETF	150.47	150.47	150.47	150.47	3000.0
2007-11-06 06:00:00	SPY	ETF	150.51	150.51	150.49	150.49	8000.0
2007-11-06 06:30:00	SPY	ETF	150.62	150.8	150.62	150.77	99000.0
2007-11-06 07:00:00	SPY	ETF	150.75	151.0	150.7	150.85	420000.0
2007-11-06 07:30:00	SPY	ETF	150.88	150.88	150.72	150.82	448500.0
2007-11-06 08:00:00	SPY	ETF	150.82	150.91	150.2	150.79	1340900.0
2007-11-06 08:30:00	SPY	ETF	150.85	150.91	150.55	150.7	1254500.0
2007-11-06 09:00:00	SPY	ETF	150.71	150.85	150.71	150.84	1815400.0
2007-11-06 09:30:00	SPY	ETF	150.86	151.14	150.71	150.96	15650453.0
2007-11-06 10:00:00	SPY	ETF	150.96	151.2	150.64	150.79	13176278.0
2007-11-06 10:30:00	SPY	ETF	150.79	150.79	149.9	150.2	19760915.0
2007-11-06 11:00:00	SPY	ETF	150.19	150.49	150.12	150.4	8912630.0
2007-11-06 11:30:00	SPY	ETF	150.41	150.7	150.16	150.49	12103145.0
2007-11-06 12:00:00	SPY	ETF	150.49	151.0	150.0	150.71	9371163.0
2007-11-06 12:30:00	SPY	ETF	150.71	150.86	150.0	150.82	6821139.0
2007-11-06 13:00:00	SPY	ETF	150.82	151.135	150.81	150.92	14488091.0
2007-11-06 13:30:00	SPY	ETF	150.91	151.33	150.86	151.03	11009404.0
2007-11-06 14:00:00	SPY	ETF	151.025	151.21	150.9	150.98	8997916.0
2007-11-06 14:30:00	SPY	ETF	150.98	151.13	150.86	151.05	9499626.0
2007-11-06 15:00:00	SPY	ETF	151.05	151.57	150.97	151.5001	14227997.0
2007-11-06 15:30:00	SPY	ETF	151.51	152.1	151.35	152.09	19125592.0
2007-11-06 16:00:00	SPY	ETF	152.1	152.11	150.27	152.0	4652000.0
2007-11-06 16:30:00	SPY	ETF	152.0	152.0	151.619	151.93	1864500.0
2007-11-06 17:00:00	SPY	ETF	151.91	152.03	151.91	151.95	407000.0
2007-11-06 17:30:00	SPY	ETF	151.96	151.96	151.82	151.92	112500.0
2007-11-06 18:00:00	SPY	ETF	151.92	151.92	151.73	151.75	77300.0
2007-11-06 18:30:00	SPY	ETF	151.75	151.78	151.7	151.74	68600.0
2007-11-06 19:00:00	SPY	ETF	151.75	151.81	151.74	151.78	12900.0
2007-11-06 19:30:00	SPY	ETF	151.76	151.76	151.72	151.76	25300.0
2007-11-06 04:00:00	QQQ	ETF	54.25	54.25	54.25	54.25	100.0
2007-11-06 06:30:00	QQQ	ETF	54.38	54.39	54.38	54.39	37700.0
2007-11-06 07:00:00	QQQ	ETF	54.38	54.44	54.35	54.43	202481.0
2007-11-06 07:30:00	QQQ	ETF	54.4	54.43	54.39	54.42	121535.0
2007-11-06 08:00:00	QQQ	ETF	54.42	54.47	54.4	54.47	515913.0
2007-11-06 08:30:00	QQQ	ETF	54.46	54.47	54.36	54.36	407051.0
2007-11-06 09:00:00	QQQ	ETF	54.36	54.43	54.3	54.33	610057.0
2007-11-06 09:30:00	QQQ	ETF	54.33	54.39	54.22	54.2977	9107889.0
2007-11-06 10:00:00	QQQ	ETF	54.29	54.4	54.13	54.2014	10929201.0
2007-11-06 10:30:00	QQQ	ETF	54.2	54.2	53.78	53.95	18512621.0
2007-11-06 11:00:00	QQQ	ETF	53.9526	54.04	53.88	53.99	8133293.0
2007-11-06 11:30:00	QQQ	ETF	53.99	54.1	53.86	54.02	9673790.0
2007-11-06 12:00:00	QQQ	ETF	54.01	54.16	53.93	54.05	6043915.0
2007-11-06 12:30:00	QQQ	ETF	54.06	54.11	54.01	54.105	4671004.0
2007-11-06 13:00:00	QQQ	ETF	54.11	54.26	54.09	54.21	7038954.0
2007-11-06 13:30:00	QQQ	ETF	54.19	54.36	54.17	54.23	8453128.0
2007-11-06 14:00:00	QQQ	ETF	54.24	54.28	54.11	54.17	8383828.0
2007-11-06 14:30:00	QQQ	ETF	54.16	54.28	54.12	54.24	6380572.0
2007-11-06 15:00:00	QQQ	ETF	54.24	54.5	54.19	54.48	11416008.0
2007-11-06 15:30:00	QQQ	ETF	54.48	54.69	54.39	54.69	14912339.0
2007-11-06 16:00:00	QQQ	ETF	54.69	54.69	43.65	54.63	5084276.0

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

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