PREVIEW / etf_30min / 2007-01-03

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-03.parquet
  size:    101 KB
  rows:    3,415

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-01-03 04:00:00	SPY	ETF	142.71	142.71	142.71	142.71	1500.0
2007-01-03 06:00:00	SPY	ETF	142.51	142.52	142.51	142.52	12500.0
2007-01-03 06:30:00	SPY	ETF	142.4	142.42	142.37	142.42	1900.0
2007-01-03 07:00:00	SPY	ETF	142.42	142.57	142.4	142.57	75600.0
2007-01-03 07:30:00	SPY	ETF	142.57	142.59	142.48	142.53	357600.0
2007-01-03 08:00:00	SPY	ETF	142.5	142.65	141.62	142.44	1426000.0
2007-01-03 08:30:00	SPY	ETF	142.42	143.17	141.62	142.43	1042600.0
2007-01-03 09:00:00	SPY	ETF	142.43	142.47	141.69	142.25	1556600.0
2007-01-03 09:30:00	SPY	ETF	142.25	142.78	141.93	142.06	10266300.0
2007-01-03 10:00:00	SPY	ETF	142.05	142.86	141.99	142.73	10820500.0
2007-01-03 10:30:00	SPY	ETF	142.72	142.8	142.55	142.58	4817500.0
2007-01-03 11:00:00	SPY	ETF	142.58	142.67	142.53	142.58	2518400.0
2007-01-03 11:30:00	SPY	ETF	142.57	142.73	142.55	142.59	2090400.0
2007-01-03 12:00:00	SPY	ETF	142.58	142.62	142.38	142.41	2513100.0
2007-01-03 12:30:00	SPY	ETF	142.41	142.61	142.4	142.56	2739000.0
2007-01-03 13:00:00	SPY	ETF	142.56	142.6	142.04	142.18	4897600.0
2007-01-03 13:30:00	SPY	ETF	142.17	142.21	142.0	142.07	3600500.0
2007-01-03 14:00:00	SPY	ETF	142.06	142.23	140.9	141.45	12714100.0
2007-01-03 14:30:00	SPY	ETF	141.45	141.53	140.57	140.7	8595800.0
2007-01-03 15:00:00	SPY	ETF	140.701	141.17	140.65	141.06	5665300.0
2007-01-03 15:30:00	SPY	ETF	141.06	141.59	141.05	141.45	7309100.0
2007-01-03 16:00:00	SPY	ETF	141.46	141.53	141.34	141.37	874100.0
2007-01-03 16:30:00	SPY	ETF	141.37	141.43	141.37	141.42	110800.0
2007-01-03 17:00:00	SPY	ETF	141.44	141.45	141.44	141.45	2800.0
2007-01-03 17:30:00	SPY	ETF	141.46	141.46	141.43	141.43	1600.0
2007-01-03 18:00:00	SPY	ETF	141.46	141.46	141.44	141.44	900.0
2007-01-03 18:30:00	SPY	ETF	141.43	141.5	141.43	141.5	400.0
2007-01-03 19:00:00	SPY	ETF	141.47	141.47	141.37	141.38	30400.0
2007-01-03 19:30:00	SPY	ETF	141.43	141.43	141.38	141.38	7500.0
2007-01-03 04:00:00	QQQ	ETF	43.56	43.56	43.56	43.56	200.0
2007-01-03 05:30:00	QQQ	ETF	43.54	43.54	43.54	43.54	4500.0
2007-01-03 06:00:00	QQQ	ETF	43.56	43.56	43.54	43.54	10000.0
2007-01-03 06:30:00	QQQ	ETF	43.51	43.51	43.51	43.51	2000.0
2007-01-03 07:00:00	QQQ	ETF	43.52	43.6	43.52	43.58	332582.0
2007-01-03 07:30:00	QQQ	ETF	43.58	43.6	43.55	43.58	187968.0
2007-01-03 08:00:00	QQQ	ETF	43.58	43.59	43.16	43.57	1536862.0
2007-01-03 08:30:00	QQQ	ETF	43.57	43.58	43.5	43.52	980325.0
2007-01-03 09:00:00	QQQ	ETF	43.52	43.53	43.46	43.46	2125374.0
2007-01-03 09:30:00	QQQ	ETF	43.46	45.6	43.43	43.54	16809800.0
2007-01-03 10:00:00	QQQ	ETF	43.5	43.89	43.49	43.88	20438900.0
2007-01-03 10:30:00	QQQ	ETF	43.87	44.06	43.86	43.95	15453300.0
2007-01-03 11:00:00	QQQ	ETF	43.94	43.98	43.88	43.91	3465200.0
2007-01-03 11:30:00	QQQ	ETF	43.91	43.98	43.89	43.9	3277300.0
2007-01-03 12:00:00	QQQ	ETF	43.9	43.91	43.78	43.79	4212300.0
2007-01-03 12:30:00	QQQ	ETF	43.78	43.92	43.78	43.84	2977000.0
2007-01-03 13:00:00	QQQ	ETF	43.85	43.88	43.71	43.75	3999900.0
2007-01-03 13:30:00	QQQ	ETF	43.74	43.76	43.58	43.61	7713200.0
2007-01-03 14:00:00	QQQ	ETF	43.61	43.67	42.85	43.02	31306600.0
2007-01-03 14:30:00	QQQ	ETF	43.02	43.03	42.52	42.68	18887900.0
2007-01-03 15:00:00	QQQ	ETF	42.69	42.96	42.64	42.95	11080600.0

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

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