PREVIEW / etf_30min / 2007-05-25

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-25.parquet
  size:    110 KB
  rows:    4,236

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-05-25 04:00:00	SPY	ETF	151.54	151.54	151.51	151.53	3100.0
2007-05-25 04:30:00	SPY	ETF	151.48	151.48	151.3	151.3	3000.0
2007-05-25 06:30:00	SPY	ETF	151.55	151.55	151.44	151.45	30000.0
2007-05-25 07:00:00	SPY	ETF	151.43	151.54	151.41	151.53	38500.0
2007-05-25 07:30:00	SPY	ETF	151.53	151.61	151.52	151.6	118400.0
2007-05-25 08:00:00	SPY	ETF	151.55	151.66	151.55	151.57	1544700.0
2007-05-25 08:30:00	SPY	ETF	151.58	151.62	151.2	151.55	414000.0
2007-05-25 09:00:00	SPY	ETF	151.54	151.56	151.42	151.48	1404800.0
2007-05-25 09:30:00	SPY	ETF	151.49	151.64	151.35	151.49	10519654.0
2007-05-25 10:00:00	SPY	ETF	151.48	151.77	151.29	151.611	13887845.0
2007-05-25 10:30:00	SPY	ETF	151.62	152.02	151.62	151.84	10255248.0
2007-05-25 11:00:00	SPY	ETF	151.84	151.87	151.65	151.68	4071500.0
2007-05-25 11:30:00	SPY	ETF	151.68	151.86	151.65	151.74	3188507.0
2007-05-25 12:00:00	SPY	ETF	151.74	151.74	151.18	151.26	7238400.0
2007-05-25 12:30:00	SPY	ETF	151.26	151.5	151.26	151.38	2481035.0
2007-05-25 13:00:00	SPY	ETF	151.38	151.76	151.37	151.63	3440814.0
2007-05-25 13:30:00	SPY	ETF	151.63	151.63	151.48	151.55	2238700.0
2007-05-25 14:00:00	SPY	ETF	151.55	151.69	151.44	151.53	4123280.0
2007-05-25 14:30:00	SPY	ETF	151.53	151.82	151.5	151.74	4469526.0
2007-05-25 15:00:00	SPY	ETF	151.74	151.84	151.63	151.72	4094936.0
2007-05-25 15:30:00	SPY	ETF	151.72	151.89	151.7	151.86	7731476.0
2007-05-25 16:00:00	SPY	ETF	151.84	151.85	151.63	151.83	1348000.0
2007-05-25 16:30:00	SPY	ETF	151.72	151.8	151.7	151.79	49900.0
2007-05-25 17:00:00	SPY	ETF	151.8	151.8	151.77	151.77	3100.0
2007-05-25 17:30:00	SPY	ETF	151.8	151.8	151.8	151.8	1100.0
2007-05-25 18:00:00	SPY	ETF	151.81	151.82	151.8	151.8	700.0
2007-05-25 19:30:00	SPY	ETF	151.8	151.82	151.8	151.82	500.0
2007-05-25 05:30:00	QQQ	ETF	46.28	46.28	46.28	46.28	200.0
2007-05-25 06:30:00	QQQ	ETF	46.27	46.27	46.27	46.27	200.0
2007-05-25 07:00:00	QQQ	ETF	46.27	46.31	46.27	46.3	395600.0
2007-05-25 07:30:00	QQQ	ETF	46.31	46.34	46.3	46.32	59126.0
2007-05-25 08:00:00	QQQ	ETF	46.31	46.35	46.3	46.33	532148.0
2007-05-25 08:30:00	QQQ	ETF	46.33	46.35	46.29	46.29	303127.0
2007-05-25 09:00:00	QQQ	ETF	46.29	46.32	46.26	46.27	1481556.0
2007-05-25 09:30:00	QQQ	ETF	46.26	46.33	46.2	46.285	11329599.0
2007-05-25 10:00:00	QQQ	ETF	46.28	46.41	46.18	46.36	12696097.0
2007-05-25 10:30:00	QQQ	ETF	46.35	46.5	46.35	46.41	9134305.0
2007-05-25 11:00:00	QQQ	ETF	46.4005	46.42	46.34	46.341	3344606.0
2007-05-25 11:30:00	QQQ	ETF	46.34	46.43	46.33	46.43	2438913.0
2007-05-25 12:00:00	QQQ	ETF	46.43	46.43	46.27	46.294	4303108.0
2007-05-25 12:30:00	QQQ	ETF	46.297	46.42	46.28	46.32	2831033.0
2007-05-25 13:00:00	QQQ	ETF	46.31	46.47	46.31	46.4	3707576.0
2007-05-25 13:30:00	QQQ	ETF	46.4	46.42	46.37	46.4101	1305402.0
2007-05-25 14:00:00	QQQ	ETF	46.42	46.48	46.39	46.4	3426366.0
2007-05-25 14:30:00	QQQ	ETF	46.41	46.55	46.4	46.52	5251250.0
2007-05-25 15:00:00	QQQ	ETF	46.51	46.56	46.47	46.5	5137649.0
2007-05-25 15:30:00	QQQ	ETF	46.5	46.53	46.45	46.46	15929962.0
2007-05-25 16:00:00	QQQ	ETF	46.46	46.48	46.42	46.43	795759.0
2007-05-25 16:30:00	QQQ	ETF	46.43	46.5	46.43	46.48	200647.0
2007-05-25 17:00:00	QQQ	ETF	46.48	46.49	46.47	46.48	7100.0

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

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