PREVIEW / etf_30min / 2007-09-04

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-04.parquet
  size:    126 KB
  rows:    4,642

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-09-04 06:00:00	SPY	ETF	147.64	147.64	147.59	147.59	35000.0
2007-09-04 06:30:00	SPY	ETF	147.56	147.56	147.29	147.29	27600.0
2007-09-04 07:00:00	SPY	ETF	147.31	147.44	147.31	147.35	87900.0
2007-09-04 07:30:00	SPY	ETF	147.3	147.49	147.25	147.39	90300.0
2007-09-04 08:00:00	SPY	ETF	147.42	147.59	147.25	147.4	547900.0
2007-09-04 08:30:00	SPY	ETF	147.39	147.74	147.31	147.41	398900.0
2007-09-04 09:00:00	SPY	ETF	147.44	147.71	147.36	147.46	547000.0
2007-09-04 09:30:00	SPY	ETF	147.45	148.24	147.4	148.18	10762967.0
2007-09-04 10:00:00	SPY	ETF	148.18	148.57	148.09	148.39	17667200.0
2007-09-04 10:30:00	SPY	ETF	148.39	148.81	148.38	148.64	9773500.0
2007-09-04 11:00:00	SPY	ETF	148.65	148.91	148.53	148.71	6858100.0
2007-09-04 11:30:00	SPY	ETF	148.71	148.86	148.62	148.68	4102900.0
2007-09-04 12:00:00	SPY	ETF	148.68	148.77	148.55	148.73	3596300.0
2007-09-04 12:30:00	SPY	ETF	148.73	148.9	148.7	148.72	3270300.0
2007-09-04 13:00:00	SPY	ETF	148.72	149.13	148.63	148.96	6575000.0
2007-09-04 13:30:00	SPY	ETF	148.96	149.13	148.85	149.02	5738100.0
2007-09-04 14:00:00	SPY	ETF	149.02	149.24	148.86	149.14	6976960.0
2007-09-04 14:30:00	SPY	ETF	149.13	149.47	149.13	149.41	5869144.0
2007-09-04 15:00:00	SPY	ETF	149.4	149.9	149.37	149.88	8436600.0
2007-09-04 15:30:00	SPY	ETF	149.87	149.98	149.18	149.23	17646100.0
2007-09-04 16:00:00	SPY	ETF	149.23	149.5856	148.75	149.0	1831500.0
2007-09-04 16:30:00	SPY	ETF	148.98	149.27	148.49	148.91	3222900.0
2007-09-04 17:00:00	SPY	ETF	148.9	148.93	147.7239	148.86	2530700.0
2007-09-04 17:30:00	SPY	ETF	148.86	148.89	148.86	148.87	10800.0
2007-09-04 18:00:00	SPY	ETF	148.87	148.89	148.79	148.84	97500.0
2007-09-04 18:30:00	SPY	ETF	149.08	149.08	148.84	148.85	392600.0
2007-09-04 19:00:00	SPY	ETF	148.86	148.89	148.86	148.86	5600.0
2007-09-04 19:30:00	SPY	ETF	148.9	148.9	148.86	148.9	1100.0
2007-09-04 07:00:00	QQQ	ETF	48.84	48.88	48.83	48.87	77199.0
2007-09-04 07:30:00	QQQ	ETF	48.85	48.91	48.85	48.91	1587.0
2007-09-04 08:00:00	QQQ	ETF	48.86	48.87	48.82	48.87	56303.0
2007-09-04 08:30:00	QQQ	ETF	48.86	48.93	48.84	48.89	463695.0
2007-09-04 09:00:00	QQQ	ETF	48.89	48.92	48.87	48.92	296116.0
2007-09-04 09:30:00	QQQ	ETF	48.93	49.32	48.91	49.3014	10501858.0
2007-09-04 10:00:00	QQQ	ETF	49.31	49.41	49.3	49.35	8742051.0
2007-09-04 10:30:00	QQQ	ETF	49.35	49.52	49.34	49.45	5866628.0
2007-09-04 11:00:00	QQQ	ETF	49.459	49.6	49.44	49.53	3336558.0
2007-09-04 11:30:00	QQQ	ETF	49.54	49.6	49.49	49.52	3223403.0
2007-09-04 12:00:00	QQQ	ETF	49.514	49.54	49.45	49.519	2703262.0
2007-09-04 12:30:00	QQQ	ETF	49.5182	49.6	49.51	49.52	2186631.0
2007-09-04 13:00:00	QQQ	ETF	49.53	49.66	49.49	49.64	4227796.0
2007-09-04 13:30:00	QQQ	ETF	49.64	49.73	49.59	49.691	4060228.0
2007-09-04 14:00:00	QQQ	ETF	49.69	49.78	49.64	49.74	3932446.0
2007-09-04 14:30:00	QQQ	ETF	49.74	49.91	49.73	49.87	5157889.0
2007-09-04 15:00:00	QQQ	ETF	49.87	49.98	49.83	49.971	7516650.0
2007-09-04 15:30:00	QQQ	ETF	49.98	50.0	49.64	49.74	20234625.0
2007-09-04 16:00:00	QQQ	ETF	49.75	49.759	49.65	49.7	2490280.0
2007-09-04 16:30:00	QQQ	ETF	49.7	49.74	49.62	49.66	408558.0
2007-09-04 17:00:00	QQQ	ETF	49.64	49.66	49.62	49.63	24865.0
2007-09-04 17:30:00	QQQ	ETF	49.67	49.67	49.67	49.67	400.0

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

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