PREVIEW / etf_30min / 2007-08-08

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-08.parquet
  size:    133 KB
  rows:    4,933

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-08 04:00:00	SPY	ETF	147.99	147.99	147.99	147.99	2000.0
2007-08-08 06:00:00	SPY	ETF	148.2	148.2	148.2	148.2	10000.0
2007-08-08 07:00:00	SPY	ETF	148.2	148.5	148.2	148.5	477900.0
2007-08-08 07:30:00	SPY	ETF	148.47	148.77	148.47	148.65	573900.0
2007-08-08 08:00:00	SPY	ETF	148.56	148.74	148.4	148.54	4799000.0
2007-08-08 08:30:00	SPY	ETF	148.51	148.65	148.44	148.45	567900.0
2007-08-08 09:00:00	SPY	ETF	148.45	148.58	148.35	148.41	3089385.0
2007-08-08 09:30:00	SPY	ETF	148.41	149.04	148.35	148.84	28298941.0
2007-08-08 10:00:00	SPY	ETF	148.84	149.42	148.72	149.29	18475395.0
2007-08-08 10:30:00	SPY	ETF	149.3	149.84	148.61	149.61	18661250.0
2007-08-08 11:00:00	SPY	ETF	149.61	149.66	148.83	149.2	16337941.0
2007-08-08 11:30:00	SPY	ETF	149.2	149.41	149.0	149.18	10810400.0
2007-08-08 12:00:00	SPY	ETF	149.17	149.31	148.9	149.23	8892675.0
2007-08-08 12:30:00	SPY	ETF	149.23	149.65	149.23	149.42	7694909.0
2007-08-08 13:00:00	SPY	ETF	149.41	149.79	149.38	149.71	7281860.0
2007-08-08 13:30:00	SPY	ETF	149.7	150.14	149.68	149.97	10616732.0
2007-08-08 14:00:00	SPY	ETF	149.97	150.59	149.77	150.42	15307709.0
2007-08-08 14:30:00	SPY	ETF	150.42	150.46	149.45	149.6	21235231.0
2007-08-08 15:00:00	SPY	ETF	149.59	149.72	147.34	148.35	40089337.0
2007-08-08 15:30:00	SPY	ETF	148.35	149.9	147.5	149.87	46361517.0
2007-08-08 16:00:00	SPY	ETF	149.92	149.99	148.7604	149.75	5035200.0
2007-08-08 16:30:00	SPY	ETF	149.77	149.92	149.73	149.82	1577900.0
2007-08-08 17:00:00	SPY	ETF	149.81	149.85	149.76	149.85	2257600.0
2007-08-08 17:30:00	SPY	ETF	149.87	149.9	149.8	149.88	70900.0
2007-08-08 18:00:00	SPY	ETF	149.85	149.87	149.81	149.86	37800.0
2007-08-08 18:30:00	SPY	ETF	149.86	149.98	149.83	149.98	194000.0
2007-08-08 19:00:00	SPY	ETF	149.96	149.96	149.92	149.92	800.0
2007-08-08 19:30:00	SPY	ETF	149.96	149.96	149.93	149.93	2100.0
2007-08-08 06:30:00	QQQ	ETF	48.44	48.44	48.43	48.43	10000.0
2007-08-08 07:00:00	QQQ	ETF	48.47	48.57	48.47	48.56	58800.0
2007-08-08 07:30:00	QQQ	ETF	48.56	48.64	48.55	48.62	192981.0
2007-08-08 08:00:00	QQQ	ETF	48.61	48.62	48.54	48.58	451457.0
2007-08-08 08:30:00	QQQ	ETF	48.57	48.6	48.51	48.51	555908.0
2007-08-08 09:00:00	QQQ	ETF	48.52	48.55	48.44	48.52	1399121.0
2007-08-08 09:30:00	QQQ	ETF	48.51	48.67	48.51	48.5899	19563455.0
2007-08-08 10:00:00	QQQ	ETF	48.59	48.73	48.56	48.66	15468971.0
2007-08-08 10:30:00	QQQ	ETF	48.646	48.83	48.62	48.74	10912648.0
2007-08-08 11:00:00	QQQ	ETF	48.7485	48.75	48.56	48.66	10699158.0
2007-08-08 11:30:00	QQQ	ETF	48.65	48.75	48.59	48.67	5423812.0
2007-08-08 12:00:00	QQQ	ETF	48.67	48.6901	48.58	48.65	6451605.0
2007-08-08 12:30:00	QQQ	ETF	48.65	48.81	48.65	48.715	5805705.0
2007-08-08 13:00:00	QQQ	ETF	48.71	48.84	48.7	48.81	4970816.0
2007-08-08 13:30:00	QQQ	ETF	48.82	48.94	48.81	48.93	6268799.0
2007-08-08 14:00:00	QQQ	ETF	48.92	49.06	48.86	49.02	8369578.0
2007-08-08 14:30:00	QQQ	ETF	49.02	49.05	48.82	48.84	10355592.0
2007-08-08 15:00:00	QQQ	ETF	48.83	48.88	48.4	48.4422	17569738.0
2007-08-08 15:30:00	QQQ	ETF	48.42	48.79	48.4	48.76	22470936.0
2007-08-08 16:00:00	QQQ	ETF	48.77	49.02	48.55	48.87	4469413.0
2007-08-08 16:30:00	QQQ	ETF	48.86	48.88	48.85	48.86	258338.0
2007-08-08 17:00:00	QQQ	ETF	48.86	48.87	48.8	48.84	813465.0

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

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