PREVIEW / etf_30min / 2007-08-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-13.parquet
  size:    128 KB
  rows:    4,755

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-08-13 04:00:00	SPY	ETF	146.11	146.16	145.94	145.94	42000.0
2007-08-13 04:30:00	SPY	ETF	145.86	145.89	145.75	145.75	3400.0
2007-08-13 05:00:00	SPY	ETF	145.74	145.75	145.67	145.75	6200.0
2007-08-13 05:30:00	SPY	ETF	145.66	145.71	145.65	145.66	37500.0
2007-08-13 06:00:00	SPY	ETF	145.64	145.84	145.64	145.84	19000.0
2007-08-13 06:30:00	SPY	ETF	145.76	145.82	145.68	145.75	20700.0
2007-08-13 07:00:00	SPY	ETF	145.75	145.99	145.7	145.81	730900.0
2007-08-13 07:30:00	SPY	ETF	145.81	146.21	145.77	146.05	1268200.0
2007-08-13 08:00:00	SPY	ETF	146.06	146.34	144.71	146.2	2003700.0
2007-08-13 08:30:00	SPY	ETF	146.29	146.57	145.35	146.44	2131900.0
2007-08-13 09:00:00	SPY	ETF	146.45	146.66	146.38	146.49	3709700.0
2007-08-13 09:30:00	SPY	ETF	146.5	146.77	146.04	146.23	20083400.0
2007-08-13 10:00:00	SPY	ETF	146.23	146.67	146.19	146.58	12299400.0
2007-08-13 10:30:00	SPY	ETF	146.57	146.62	145.98	146.25	12066300.0
2007-08-13 11:00:00	SPY	ETF	146.27	146.58	145.88	146.52	11087600.0
2007-08-13 11:30:00	SPY	ETF	146.51	146.89	146.29	146.62	10468100.0
2007-08-13 12:00:00	SPY	ETF	146.629	146.65	146.13	146.14	8669800.0
2007-08-13 12:30:00	SPY	ETF	146.15	146.31	145.92	146.215	7545100.0
2007-08-13 13:00:00	SPY	ETF	146.22	146.64	145.55	145.85	13593100.0
2007-08-13 13:30:00	SPY	ETF	145.84	146.64	145.68	146.21	7467600.0
2007-08-13 14:00:00	SPY	ETF	146.21	146.58	145.94	146.45	11133000.0
2007-08-13 14:30:00	SPY	ETF	146.43	146.49	146.07	146.11	9699600.0
2007-08-13 15:00:00	SPY	ETF	146.12	146.28	145.56	146.07	11147900.0
2007-08-13 15:30:00	SPY	ETF	146.07	146.31	145.28	145.51	20370500.0
2007-08-13 16:00:00	SPY	ETF	145.48	145.64	145.02	145.2	4239300.0
2007-08-13 16:30:00	SPY	ETF	145.19	145.3	145.01	145.06	1042700.0
2007-08-13 17:00:00	SPY	ETF	145.05	145.5469	144.9	145.05	1833500.0
2007-08-13 17:30:00	SPY	ETF	145.05	145.2	145.05	145.09	4425000.0
2007-08-13 18:00:00	SPY	ETF	145.06	145.1	145.0	145.1	35100.0
2007-08-13 18:30:00	SPY	ETF	145.1	145.12	145.06	145.08	25500.0
2007-08-13 19:00:00	SPY	ETF	145.05	145.05	144.9	144.91	31500.0
2007-08-13 19:30:00	SPY	ETF	144.94	144.96	144.88	144.95	11100.0
2007-08-13 04:00:00	QQQ	ETF	47.59	47.59	47.59	47.59	200.0
2007-08-13 05:30:00	QQQ	ETF	47.41	47.44	47.41	47.44	20000.0
2007-08-13 06:00:00	QQQ	ETF	47.42	47.49	47.42	47.49	5200.0
2007-08-13 06:30:00	QQQ	ETF	47.47	47.51	47.46	47.5	60200.0
2007-08-13 07:00:00	QQQ	ETF	47.49	47.57	47.48	47.55	196691.0
2007-08-13 07:30:00	QQQ	ETF	47.52	47.61	47.52	47.6	106420.0
2007-08-13 08:00:00	QQQ	ETF	47.6	47.67	47.39	47.66	373264.0
2007-08-13 08:30:00	QQQ	ETF	47.67	47.76	47.67	47.73	852445.0
2007-08-13 09:00:00	QQQ	ETF	47.73	47.78	47.65	47.68	2425415.0
2007-08-13 09:30:00	QQQ	ETF	47.68	47.74	47.54	47.59	13435296.0
2007-08-13 10:00:00	QQQ	ETF	47.586	47.81	47.56	47.7886	7631046.0
2007-08-13 10:30:00	QQQ	ETF	47.79	47.8	47.58	47.67	7662732.0
2007-08-13 11:00:00	QQQ	ETF	47.67	47.828	47.59	47.78	8541872.0
2007-08-13 11:30:00	QQQ	ETF	47.789	47.88	47.73	47.81	5582234.0
2007-08-13 12:00:00	QQQ	ETF	47.8115	47.85	47.64	47.658	7900151.0
2007-08-13 12:30:00	QQQ	ETF	47.66	47.77	47.62	47.75	4023752.0
2007-08-13 13:00:00	QQQ	ETF	47.74	47.76	47.48	47.59	7185853.0
2007-08-13 13:30:00	QQQ	ETF	47.59	47.71	47.52	47.6915	5014391.0

> showing 50 of 4,755 rows — these rows as CSV

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