PREVIEW / etf_30min / 2007-07-31

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-31.parquet
  size:    134 KB
  rows:    5,008

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-07-31 05:30:00	SPY	ETF	147.89	147.89	147.89	147.89	5000.0
2007-07-31 06:00:00	SPY	ETF	147.88	147.91	147.88	147.91	6800.0
2007-07-31 06:30:00	SPY	ETF	148.0	148.2	148.0	148.2	296500.0
2007-07-31 07:00:00	SPY	ETF	148.22	148.58	148.22	148.58	1922600.0
2007-07-31 07:30:00	SPY	ETF	148.57	148.7	148.44	148.55	1606900.0
2007-07-31 08:00:00	SPY	ETF	148.58	148.81	148.04	148.79	5170300.0
2007-07-31 08:30:00	SPY	ETF	148.84	148.95	147.23	148.23	7242600.0
2007-07-31 09:00:00	SPY	ETF	148.23	148.42	147.22	148.34	3058400.0
2007-07-31 09:30:00	SPY	ETF	148.32	149.32	147.66	148.47	23874523.0
2007-07-31 10:00:00	SPY	ETF	148.48	149.46	147.96	147.98	28438215.0
2007-07-31 10:30:00	SPY	ETF	147.98	148.78	147.38	147.7	25246914.0
2007-07-31 11:00:00	SPY	ETF	147.69	148.73	147.53	147.97	16807930.0
2007-07-31 11:30:00	SPY	ETF	147.96	148.32	147.88	148.2	13415991.0
2007-07-31 12:00:00	SPY	ETF	148.1901	148.35	148.0	148.28	7829432.0
2007-07-31 12:30:00	SPY	ETF	148.28	148.39	148.05	148.19	6841259.0
2007-07-31 13:00:00	SPY	ETF	148.2	149.18	147.95	147.96	10756302.0
2007-07-31 13:30:00	SPY	ETF	147.96	148.05	147.28	147.73	21565966.0
2007-07-31 14:00:00	SPY	ETF	147.73	147.92	147.25	147.3	20214519.0
2007-07-31 14:30:00	SPY	ETF	147.3	147.46	146.37	146.79	34890574.0
2007-07-31 15:00:00	SPY	ETF	146.79	147.32	146.75	146.82	20560533.0
2007-07-31 15:30:00	SPY	ETF	146.82	147.33	145.39	145.39	39314298.0
2007-07-31 16:00:00	SPY	ETF	145.33	147.3804	145.05	145.62	13110900.0
2007-07-31 16:30:00	SPY	ETF	147.3804	147.3804	145.41	145.61	2758100.0
2007-07-31 17:00:00	SPY	ETF	145.62	145.7	145.48	145.56	348800.0
2007-07-31 17:30:00	SPY	ETF	145.56	145.65	145.5	145.5	2424300.0
2007-07-31 18:00:00	SPY	ETF	145.52	145.52	145.09	145.11	336100.0
2007-07-31 18:30:00	SPY	ETF	145.07	145.25	145.06	145.08	276500.0
2007-07-31 19:00:00	SPY	ETF	145.11	145.17	145.0	145.08	86400.0
2007-07-31 19:30:00	SPY	ETF	145.08	145.09	144.96	144.98	60300.0
2007-07-31 04:00:00	QQQ	ETF	48.69	48.69	48.69	48.69	200.0
2007-07-31 04:30:00	QQQ	ETF	48.73	48.73	48.73	48.73	200.0
2007-07-31 06:30:00	QQQ	ETF	48.92	48.92	48.92	48.92	50000.0
2007-07-31 07:00:00	QQQ	ETF	48.95	49.01	48.95	49.0	679597.0
2007-07-31 07:30:00	QQQ	ETF	49.0	49.15	48.85	48.92	617260.0
2007-07-31 08:00:00	QQQ	ETF	48.92	49.09	48.91	49.06	3759444.0
2007-07-31 08:30:00	QQQ	ETF	49.07	49.1	48.85	48.86	2210348.0
2007-07-31 09:00:00	QQQ	ETF	48.86	48.98	48.86	48.97	4088358.0
2007-07-31 09:30:00	QQQ	ETF	48.97	48.98	48.79	48.91	15450105.0
2007-07-31 10:00:00	QQQ	ETF	48.91	49.93	48.65	48.65	23563811.0
2007-07-31 10:30:00	QQQ	ETF	48.6515	48.67	48.31	48.456	25380109.0
2007-07-31 11:00:00	QQQ	ETF	48.45	48.54	48.31	48.43	14009959.0
2007-07-31 11:30:00	QQQ	ETF	48.42	48.56	48.4	48.51	13583146.0
2007-07-31 12:00:00	QQQ	ETF	48.51	48.57	48.3705	48.5	15774634.0
2007-07-31 12:30:00	QQQ	ETF	48.5	48.55	48.38	48.41	5382612.0
2007-07-31 13:00:00	QQQ	ETF	48.41	48.5	48.33	48.34	8269004.0
2007-07-31 13:30:00	QQQ	ETF	48.33	48.38	48.08	48.27	9566084.0
2007-07-31 14:00:00	QQQ	ETF	48.27	48.36	48.1	48.1785	17694046.0
2007-07-31 14:30:00	QQQ	ETF	48.17	48.79	47.77	47.9	30699870.0
2007-07-31 15:00:00	QQQ	ETF	47.89	48.19	47.89	48.03	20090650.0
2007-07-31 15:30:00	QQQ	ETF	48.04	48.09	47.45	47.45	27613014.0

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

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