PREVIEW / etf_30min / 2007-12-04

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-04.parquet
  size:    134 KB
  rows:    5,086

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-12-04 04:00:00	SPY	ETF	147.21	147.21	147.21	147.21	1500.0
2007-12-04 05:00:00	SPY	ETF	147.16	147.16	146.98	146.98	10100.0
2007-12-04 05:30:00	SPY	ETF	146.96	147.14	146.96	147.07	6400.0
2007-12-04 06:00:00	SPY	ETF	147.07	147.07	147.07	147.07	3000.0
2007-12-04 06:30:00	SPY	ETF	146.99	147.02	146.97	147.02	49000.0
2007-12-04 07:00:00	SPY	ETF	147.0	147.1	146.8	146.86	279000.0
2007-12-04 07:30:00	SPY	ETF	146.88	146.89	146.64	146.7	494100.0
2007-12-04 08:00:00	SPY	ETF	146.71	147.1	146.65	146.78	1703800.0
2007-12-04 08:30:00	SPY	ETF	146.78	147.05	146.75	146.87	1441400.0
2007-12-04 09:00:00	SPY	ETF	146.88	147.1	146.61	146.65	931600.0
2007-12-04 09:30:00	SPY	ETF	146.66	146.95	146.31	146.95	26627332.0
2007-12-04 10:00:00	SPY	ETF	146.94	147.02	146.64	146.96	8210478.0
2007-12-04 10:30:00	SPY	ETF	146.95	147.16	146.78	146.83	7912316.0
2007-12-04 11:00:00	SPY	ETF	146.82	147.11	146.73	146.78	5878427.0
2007-12-04 11:30:00	SPY	ETF	146.78	146.88	146.62	146.68	6912933.0
2007-12-04 12:00:00	SPY	ETF	146.68	147.16	146.68	147.09	8880555.0
2007-12-04 12:30:00	SPY	ETF	147.1	147.31	146.93	147.17	4900264.0
2007-12-04 13:00:00	SPY	ETF	147.17	147.34	146.84	146.88	7331730.0
2007-12-04 13:30:00	SPY	ETF	146.89	147.11	146.83	146.9774	6238335.0
2007-12-04 14:00:00	SPY	ETF	146.97	147.5409	146.6	146.78	9706680.0
2007-12-04 14:30:00	SPY	ETF	146.78	147.1	146.74	147.02	6756526.0
2007-12-04 15:00:00	SPY	ETF	147.02	147.17	146.79	146.86	9935840.0
2007-12-04 15:30:00	SPY	ETF	146.88	147.01	146.51	146.56	16924131.0
2007-12-04 16:00:00	SPY	ETF	146.58	147.5409	146.35	146.49	2348600.0
2007-12-04 16:30:00	SPY	ETF	146.43	146.53	146.42	146.53	342100.0
2007-12-04 17:00:00	SPY	ETF	146.55	146.6	146.36	146.55	54634.0
2007-12-04 17:30:00	SPY	ETF	146.54	146.59	146.5	146.59	6700.0
2007-12-04 18:00:00	SPY	ETF	146.57	146.57	146.46	146.51	43600.0
2007-12-04 19:00:00	SPY	ETF	146.51	146.51	146.43	146.43	2000.0
2007-12-04 19:30:00	SPY	ETF	146.52	146.66	146.52	146.66	3300.0
2007-12-04 06:00:00	QQQ	ETF	50.78	50.79	50.76	50.76	11200.0
2007-12-04 06:30:00	QQQ	ETF	50.76	50.76	50.7	50.75	30800.0
2007-12-04 07:00:00	QQQ	ETF	50.75	50.76	50.55	50.57	364323.0
2007-12-04 07:30:00	QQQ	ETF	50.57	50.58	50.46	50.5	577541.0
2007-12-04 08:00:00	QQQ	ETF	50.5	50.6	50.46	50.51	2102073.0
2007-12-04 08:30:00	QQQ	ETF	50.52	50.62	50.52	50.58	1530274.0
2007-12-04 09:00:00	QQQ	ETF	50.6	50.64	50.42	50.47	1253116.0
2007-12-04 09:30:00	QQQ	ETF	50.46	50.78	50.38	50.77	22005247.0
2007-12-04 10:00:00	QQQ	ETF	50.76	50.81	50.65	50.78	10538798.0
2007-12-04 10:30:00	QQQ	ETF	50.77	50.92	50.75	50.76	8905948.0
2007-12-04 11:00:00	QQQ	ETF	50.76	50.912	50.73	50.77	5406342.0
2007-12-04 11:30:00	QQQ	ETF	50.78	50.82	50.7	50.73	4927984.0
2007-12-04 12:00:00	QQQ	ETF	50.73	50.86	50.69	50.83	7760395.0
2007-12-04 12:30:00	QQQ	ETF	50.84	50.9	50.77	50.8699	2827669.0
2007-12-04 13:00:00	QQQ	ETF	50.86	50.94	50.73	50.74	4428322.0
2007-12-04 13:30:00	QQQ	ETF	50.74	50.83	50.71	50.7701	3454746.0
2007-12-04 14:00:00	QQQ	ETF	50.78	50.79	50.53	50.622	6889640.0
2007-12-04 14:30:00	QQQ	ETF	50.62	50.8	50.62	50.76	6607722.0
2007-12-04 15:00:00	QQQ	ETF	50.76	50.79	50.64	50.68	7532830.0
2007-12-04 15:30:00	QQQ	ETF	50.69	50.74	50.53	50.66	13996194.0

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

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