PREVIEW / etf_30min / 2007-05-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-02.parquet
  size:    108 KB
  rows:    3,875

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-02 04:00:00	SPY	ETF	148.71	148.71	148.71	148.71	8000.0
2007-05-02 04:30:00	SPY	ETF	149.23	149.23	149.14	149.14	5000.0
2007-05-02 05:00:00	SPY	ETF	149.14	149.14	149.14	149.14	13000.0
2007-05-02 05:30:00	SPY	ETF	149.1	149.1	149.1	149.1	500.0
2007-05-02 06:00:00	SPY	ETF	149.04	149.04	149.04	149.04	1000.0
2007-05-02 07:00:00	SPY	ETF	149.02	149.05	149.02	149.03	6900.0
2007-05-02 07:30:00	SPY	ETF	149.03	149.03	148.97	149.0	14500.0
2007-05-02 08:00:00	SPY	ETF	149.12	149.26	148.87	148.97	1256000.0
2007-05-02 08:30:00	SPY	ETF	148.98	148.98	148.84	148.89	538500.0
2007-05-02 09:00:00	SPY	ETF	148.89	148.95	148.76	148.89	1191939.0
2007-05-02 09:30:00	SPY	ETF	148.9	149.2	148.75	149.17	12185711.0
2007-05-02 10:00:00	SPY	ETF	149.17	149.47	149.17	149.39	10962976.0
2007-05-02 10:30:00	SPY	ETF	149.39	149.79	149.38	149.72	11252811.0
2007-05-02 11:00:00	SPY	ETF	149.72	149.74	149.58	149.59	3829066.0
2007-05-02 11:30:00	SPY	ETF	149.59	149.64	149.51	149.56	3156147.0
2007-05-02 12:00:00	SPY	ETF	149.56	149.74	149.53	149.7	4088815.0
2007-05-02 12:30:00	SPY	ETF	149.7	149.77	149.57	149.64	2900720.0
2007-05-02 13:00:00	SPY	ETF	149.64	149.87	149.64	149.77	4477333.0
2007-05-02 13:30:00	SPY	ETF	149.76	149.86	149.74	149.78	3619229.0
2007-05-02 14:00:00	SPY	ETF	149.78	149.95	149.71	149.91	6170077.0
2007-05-02 14:30:00	SPY	ETF	149.9	149.92	149.76	149.78	2862184.0
2007-05-02 15:00:00	SPY	ETF	149.78	149.8	149.58	149.72	6325719.0
2007-05-02 15:30:00	SPY	ETF	149.71	149.73	149.47	149.62	8737624.0
2007-05-02 16:00:00	SPY	ETF	149.62	149.67	149.53	149.54	1721900.0
2007-05-02 16:30:00	SPY	ETF	149.57	149.59	149.52	149.54	153700.0
2007-05-02 17:00:00	SPY	ETF	149.57	149.58	149.53	149.53	13500.0
2007-05-02 17:30:00	SPY	ETF	149.52	149.54	149.48	149.5	51700.0
2007-05-02 18:00:00	SPY	ETF	149.55	149.55	149.54	149.54	1100.0
2007-05-02 18:30:00	SPY	ETF	149.54	149.54	149.54	149.54	900.0
2007-05-02 19:00:00	SPY	ETF	149.57	149.57	149.57	149.57	1000.0
2007-05-02 19:30:00	SPY	ETF	149.59	149.59	149.59	149.59	400.0
2007-05-02 04:00:00	QQQ	ETF	46.06	46.23	46.06	46.23	27100.0
2007-05-02 05:30:00	QQQ	ETF	46.21	46.21	46.21	46.21	200.0
2007-05-02 06:00:00	QQQ	ETF	46.21	46.21	46.21	46.21	28515.0
2007-05-02 06:30:00	QQQ	ETF	46.21	46.21	46.21	46.21	15632.0
2007-05-02 07:00:00	QQQ	ETF	46.17	46.18	46.17	46.17	21900.0
2007-05-02 07:30:00	QQQ	ETF	46.17	46.17	46.15	46.17	14100.0
2007-05-02 08:00:00	QQQ	ETF	46.17	46.21	46.11	46.13	1220153.0
2007-05-02 08:30:00	QQQ	ETF	46.14	46.15	46.11	46.12	1041439.0
2007-05-02 09:00:00	QQQ	ETF	46.12	46.14	46.08	46.1	939833.0
2007-05-02 09:30:00	QQQ	ETF	46.09	46.25	46.05	46.2	11036895.0
2007-05-02 10:00:00	QQQ	ETF	46.2	46.39	46.2	46.31	10922935.0
2007-05-02 10:30:00	QQQ	ETF	46.31	46.45	46.31	46.39	7008006.0
2007-05-02 11:00:00	QQQ	ETF	46.39	46.41	46.34	46.36	3081660.0
2007-05-02 11:30:00	QQQ	ETF	46.36	46.43	46.36	46.38	5978598.0
2007-05-02 12:00:00	QQQ	ETF	46.38	46.5	46.37	46.4694	3804471.0
2007-05-02 12:30:00	QQQ	ETF	46.47	46.5	46.42	46.43	2520290.0
2007-05-02 13:00:00	QQQ	ETF	46.44	46.51	46.42	46.47	3722066.0
2007-05-02 13:30:00	QQQ	ETF	46.47	46.56	46.46	46.54	5846915.0
2007-05-02 14:00:00	QQQ	ETF	46.54	46.58	46.52	46.58	5143255.0

> showing 50 of 3,875 rows — these rows as CSV

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