PREVIEW / etf_30min / 2007-10-09

all etf 30-min files

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

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-10-09 06:30:00	SPY	ETF	155.32	155.34	155.32	155.34	95300.0
2007-10-09 07:00:00	SPY	ETF	155.36	155.43	155.36	155.37	177900.0
2007-10-09 07:30:00	SPY	ETF	155.4	155.44	155.4	155.43	54000.0
2007-10-09 08:00:00	SPY	ETF	155.42	155.6	155.39	155.57	1043400.0
2007-10-09 08:30:00	SPY	ETF	155.58	155.65	155.54	155.55	373700.0
2007-10-09 09:00:00	SPY	ETF	155.58	155.6	155.54	155.59	316484.0
2007-10-09 09:30:00	SPY	ETF	155.6	155.71	155.44	155.49	10336352.0
2007-10-09 10:00:00	SPY	ETF	155.48	155.54	155.24	155.31	9339300.0
2007-10-09 10:30:00	SPY	ETF	155.31	155.55	155.18	155.54	6136900.0
2007-10-09 11:00:00	SPY	ETF	155.54	155.65	155.45	155.48	5032699.0
2007-10-09 11:30:00	SPY	ETF	155.48	155.58	155.38	155.56	3593600.0
2007-10-09 12:00:00	SPY	ETF	155.56	155.59	155.45	155.47	2054100.0
2007-10-09 12:30:00	SPY	ETF	155.47	155.48	155.25	155.3501	2440200.0
2007-10-09 13:00:00	SPY	ETF	155.35	155.41	155.06	155.0921	4657189.0
2007-10-09 13:30:00	SPY	ETF	155.09	155.39	155.03	155.31	4293200.0
2007-10-09 14:00:00	SPY	ETF	155.3	155.77	155.11	155.74	9449696.0
2007-10-09 14:30:00	SPY	ETF	155.74	156.1	155.73	156.04	8967100.0
2007-10-09 15:00:00	SPY	ETF	156.05	156.35	155.89	156.26	10698900.0
2007-10-09 15:30:00	SPY	ETF	156.26	156.44	156.11	156.41	8314289.0
2007-10-09 16:00:00	SPY	ETF	156.41	156.51	155.1357	156.44	3210500.0
2007-10-09 16:30:00	SPY	ETF	156.4	156.42	156.3	156.35	1120600.0
2007-10-09 17:00:00	SPY	ETF	156.36	156.36	156.25	156.29	273500.0
2007-10-09 17:30:00	SPY	ETF	156.28	156.3	156.25	156.25	34300.0
2007-10-09 18:00:00	SPY	ETF	156.29	156.48	156.25	156.27	135700.0
2007-10-09 18:30:00	SPY	ETF	156.25	156.32	156.25	156.32	51300.0
2007-10-09 19:00:00	SPY	ETF	156.33	156.33	156.3	156.3	200.0
2007-10-09 19:30:00	SPY	ETF	156.26	156.26	156.24	156.24	1600.0
2007-10-09 04:00:00	QQQ	ETF	53.14	53.14	53.14	53.14	200.0
2007-10-09 04:30:00	QQQ	ETF	53.15	53.15	53.15	53.15	5800.0
2007-10-09 05:30:00	QQQ	ETF	53.14	53.14	53.14	53.14	500.0
2007-10-09 06:00:00	QQQ	ETF	53.17	53.17	53.17	53.17	500.0
2007-10-09 07:00:00	QQQ	ETF	53.2	53.22	53.19	53.22	43900.0
2007-10-09 07:30:00	QQQ	ETF	53.22	53.23	53.2	53.23	16238.0
2007-10-09 08:00:00	QQQ	ETF	53.22	53.3	53.21	53.29	135614.0
2007-10-09 08:30:00	QQQ	ETF	53.29	53.29	53.25	53.27	195157.0
2007-10-09 09:00:00	QQQ	ETF	53.27	53.31	53.25	53.27	386952.0
2007-10-09 09:30:00	QQQ	ETF	53.27	53.34	53.2	53.22	13271953.0
2007-10-09 10:00:00	QQQ	ETF	53.22	53.25	53.09	53.16	8430768.0
2007-10-09 10:30:00	QQQ	ETF	53.16	53.22	53.07	53.21	6315467.0
2007-10-09 11:00:00	QQQ	ETF	53.21	53.27	53.18	53.209	5422711.0
2007-10-09 11:30:00	QQQ	ETF	53.209	53.25	53.14	53.24	3041614.0
2007-10-09 12:00:00	QQQ	ETF	53.24	53.26	53.18	53.229	2396734.0
2007-10-09 12:30:00	QQQ	ETF	53.229	53.23	53.13	53.16	3142972.0
2007-10-09 13:00:00	QQQ	ETF	53.16	53.18	53.07	53.07	6572196.0
2007-10-09 13:30:00	QQQ	ETF	53.07	53.18	53.03	53.16	5888547.0
2007-10-09 14:00:00	QQQ	ETF	53.16	53.28	53.09	53.26	10681707.0
2007-10-09 14:30:00	QQQ	ETF	53.26	53.38	53.26	53.3685	7114757.0
2007-10-09 15:00:00	QQQ	ETF	53.36	53.45	53.3	53.41	6022438.0
2007-10-09 15:30:00	QQQ	ETF	53.41	53.41	53.28	53.38	7237280.0
2007-10-09 16:00:00	QQQ	ETF	53.38	53.44	53.1785	53.41	7388791.0

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

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