PREVIEW / etf_30min / 2007-08-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-17.parquet
  size:    135 KB
  rows:    4,899

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-17 04:00:00	SPY	ETF	141.58	141.58	141.3	141.5	10300.0
2007-08-17 04:30:00	SPY	ETF	141.51	141.6	141.41	141.6	800.0
2007-08-17 05:00:00	SPY	ETF	141.46	141.47	141.1	141.1	3400.0
2007-08-17 05:30:00	SPY	ETF	141.04	141.04	140.7	140.9	1400.0
2007-08-17 06:00:00	SPY	ETF	140.7	140.98	140.54	140.54	134800.0
2007-08-17 06:30:00	SPY	ETF	140.68	141.19	140.68	140.8	131400.0
2007-08-17 07:00:00	SPY	ETF	140.8	140.99	140.64	140.69	900600.0
2007-08-17 07:30:00	SPY	ETF	140.69	141.47	140.69	141.45	1556500.0
2007-08-17 08:00:00	SPY	ETF	141.44	163.61	140.7	144.43	22037300.0
2007-08-17 08:30:00	SPY	ETF	144.43	145.8	141.1	144.67	18648600.0
2007-08-17 09:00:00	SPY	ETF	144.63	145.83	143.62	145.56	10278090.0
2007-08-17 09:30:00	SPY	ETF	145.5	145.81	144.03	144.17	53384108.0
2007-08-17 10:00:00	SPY	ETF	144.16	145.5	143.29	143.42	35138596.0
2007-08-17 10:30:00	SPY	ETF	143.41	145.53	142.32	143.1	37883830.0
2007-08-17 11:00:00	SPY	ETF	143.1	143.63	142.65	143.31	22363596.0
2007-08-17 11:30:00	SPY	ETF	143.31	148.35	143.07	143.4	20817567.0
2007-08-17 12:00:00	SPY	ETF	143.39	144.17	143.03	143.65	13065568.0
2007-08-17 12:30:00	SPY	ETF	143.64	144.06	143.47	143.65	13190160.0
2007-08-17 13:00:00	SPY	ETF	143.65	144.71	143.65	144.3	22549068.0
2007-08-17 13:30:00	SPY	ETF	144.3	145.264	143.88	144.04	15157434.0
2007-08-17 14:00:00	SPY	ETF	144.04	144.2	142.6	143.99	13036659.0
2007-08-17 14:30:00	SPY	ETF	143.99	145.2	143.74	144.12	9464986.0
2007-08-17 15:00:00	SPY	ETF	144.12	145.11	144.01	144.5	25973911.0
2007-08-17 15:30:00	SPY	ETF	144.49	145.9	144.48	144.74	34953738.0
2007-08-17 16:00:00	SPY	ETF	144.63	145.7	144.55	144.9	3289300.0
2007-08-17 16:30:00	SPY	ETF	144.9	145.75	141.6	141.6	4785900.0
2007-08-17 17:00:00	SPY	ETF	144.75	145.6	143.505	144.85	826800.0
2007-08-17 17:30:00	SPY	ETF	144.75	144.88	144.71	144.88	183000.0
2007-08-17 18:00:00	SPY	ETF	144.8	144.99	144.7	144.73	56000.0
2007-08-17 18:30:00	SPY	ETF	144.78	144.85	144.74	144.85	23800.0
2007-08-17 19:00:00	SPY	ETF	144.8	144.8	144.73	144.8	10700.0
2007-08-17 19:30:00	SPY	ETF	144.79	144.8	144.7	144.8	27200.0
2007-08-17 04:00:00	QQQ	ETF	45.3	45.3	45.27	45.27	400.0
2007-08-17 04:30:00	QQQ	ETF	45.35	45.35	45.35	45.35	300.0
2007-08-17 05:30:00	QQQ	ETF	45.1	45.1	45.1	45.1	200.0
2007-08-17 06:00:00	QQQ	ETF	45.07	45.14	45.05	45.05	72200.0
2007-08-17 06:30:00	QQQ	ETF	45.21	45.21	45.21	45.21	1000.0
2007-08-17 07:00:00	QQQ	ETF	45.13	45.13	44.99	44.99	517216.0
2007-08-17 07:30:00	QQQ	ETF	45.0	45.26	45.0	45.24	777100.0
2007-08-17 08:00:00	QQQ	ETF	45.24	47.14	45.22	46.25	12336046.0
2007-08-17 08:30:00	QQQ	ETF	46.26	46.55	46.1	46.13	7722892.0
2007-08-17 09:00:00	QQQ	ETF	46.14	46.58	46.12	46.28	6431541.0
2007-08-17 09:30:00	QQQ	ETF	46.31	46.5895	46.0	46.03	40733364.0
2007-08-17 10:00:00	QQQ	ETF	46.03	46.16	45.74	45.78	20872783.0
2007-08-17 10:30:00	QQQ	ETF	45.78	45.91	45.589	45.79	21574429.0
2007-08-17 11:00:00	QQQ	ETF	45.79	45.97	45.64	45.85	13147149.0
2007-08-17 11:30:00	QQQ	ETF	45.86	46.11	45.78	45.9	14316025.0
2007-08-17 12:00:00	QQQ	ETF	45.9099	45.949	45.71	45.87	8967363.0
2007-08-17 12:30:00	QQQ	ETF	45.87	46.0	45.82	45.89	6118094.0
2007-08-17 13:00:00	QQQ	ETF	45.89	46.26	45.88	46.1494	8861750.0

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

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