PREVIEW / etf_30min / 2007-03-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-06.parquet
  size:    110 KB
  rows:    3,738

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-03-06 05:00:00	SPY	ETF	138.66	138.66	138.66	138.66	300.0
2007-03-06 05:30:00	SPY	ETF	138.74	138.74	138.74	138.74	100.0
2007-03-06 06:00:00	SPY	ETF	138.9	139.05	138.9	139.05	47900.0
2007-03-06 06:30:00	SPY	ETF	139.1	139.1	138.76	138.79	136900.0
2007-03-06 07:00:00	SPY	ETF	138.85	138.86	138.64	138.77	824200.0
2007-03-06 07:30:00	SPY	ETF	138.75	138.9	138.69	138.81	445300.0
2007-03-06 08:00:00	SPY	ETF	138.84	138.95	138.1	138.69	2651800.0
2007-03-06 08:30:00	SPY	ETF	138.65	138.94	138.45	138.8	2119000.0
2007-03-06 09:00:00	SPY	ETF	138.79	138.79	138.71	138.77	955300.0
2007-03-06 09:30:00	SPY	ETF	138.78	139.25	138.74	139.04	14648500.0
2007-03-06 10:00:00	SPY	ETF	139.05	139.08	138.64	139.04	10625000.0
2007-03-06 10:30:00	SPY	ETF	139.03	139.07	138.44	138.51	6976600.0
2007-03-06 11:00:00	SPY	ETF	138.509	138.98	137.95	138.97	5393500.0
2007-03-06 11:30:00	SPY	ETF	138.97	139.2	138.81	139.09	6304900.0
2007-03-06 12:00:00	SPY	ETF	139.1	139.19	138.92	139.02	4062900.0
2007-03-06 12:30:00	SPY	ETF	139.02	139.3	139.0	139.29	7267700.0
2007-03-06 13:00:00	SPY	ETF	139.28	139.34	139.07	139.25	4528200.0
2007-03-06 13:30:00	SPY	ETF	139.249	139.63	139.15	139.5	19726200.0
2007-03-06 14:00:00	SPY	ETF	139.5	139.66	139.4	139.65	8641700.0
2007-03-06 14:30:00	SPY	ETF	139.65	139.85	139.47	139.85	6959100.0
2007-03-06 15:00:00	SPY	ETF	139.85	140.12	139.79	139.99	14263200.0
2007-03-06 15:30:00	SPY	ETF	139.99	140.0	139.71	139.8	14338100.0
2007-03-06 16:00:00	SPY	ETF	139.81	139.85	139.65	139.72	3495800.0
2007-03-06 16:30:00	SPY	ETF	139.73	139.81	138.89	138.89	4440800.0
2007-03-06 17:00:00	SPY	ETF	139.7	139.82	139.7	139.75	300200.0
2007-03-06 17:30:00	SPY	ETF	139.76	139.83	139.76	139.77	5500.0
2007-03-06 18:00:00	SPY	ETF	139.77	139.85	139.73	139.85	45400.0
2007-03-06 18:30:00	SPY	ETF	139.84	139.84	139.82	139.82	1800.0
2007-03-06 19:00:00	SPY	ETF	139.81	139.9	139.81	139.89	7800.0
2007-03-06 19:30:00	SPY	ETF	139.84	139.9	139.84	139.88	58600.0
2007-03-06 05:00:00	QQQ	ETF	42.51	42.51	42.51	42.51	20000.0
2007-03-06 05:30:00	QQQ	ETF	42.53	42.53	42.53	42.53	200.0
2007-03-06 06:00:00	QQQ	ETF	42.61	42.64	42.6	42.6	35000.0
2007-03-06 06:30:00	QQQ	ETF	42.62	42.64	42.62	42.63	41179.0
2007-03-06 07:00:00	QQQ	ETF	42.52	42.58	42.48	42.51	280718.0
2007-03-06 07:30:00	QQQ	ETF	42.53	42.62	42.51	42.55	529169.0
2007-03-06 08:00:00	QQQ	ETF	42.56	42.58	42.48	42.49	872442.0
2007-03-06 08:30:00	QQQ	ETF	42.49	42.57	42.43	42.54	2316966.0
2007-03-06 09:00:00	QQQ	ETF	42.55	42.57	42.5	42.56	1185119.0
2007-03-06 09:30:00	QQQ	ETF	42.55	42.72	42.53	42.63	26284500.0
2007-03-06 10:00:00	QQQ	ETF	42.62	42.65	42.51	42.63	18376500.0
2007-03-06 10:30:00	QQQ	ETF	42.63	42.66	42.5	42.53	12749100.0
2007-03-06 11:00:00	QQQ	ETF	42.53	42.62	42.51	42.61	6555700.0
2007-03-06 11:30:00	QQQ	ETF	42.62	42.7	42.56	42.69	9678400.0
2007-03-06 12:00:00	QQQ	ETF	42.68	42.76	42.64	42.68	7110000.0
2007-03-06 12:30:00	QQQ	ETF	42.69	42.77	42.68	42.73	4161500.0
2007-03-06 13:00:00	QQQ	ETF	42.73	42.76	42.69	42.75	4785000.0
2007-03-06 13:30:00	QQQ	ETF	42.74	42.83	42.71	42.81	7468000.0
2007-03-06 14:00:00	QQQ	ETF	42.81	42.84	42.75	42.81	6320800.0
2007-03-06 14:30:00	QQQ	ETF	42.82	42.88	42.79	42.87	5137000.0

> showing 50 of 3,738 rows — these rows as CSV

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