PREVIEW / etf_30min / 2007-05-22

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-22.parquet
  size:    114 KB
  rows:    4,449

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-22 07:00:00	SPY	ETF	152.83	152.85	152.78	152.8	34400.0
2007-05-22 07:30:00	SPY	ETF	152.79	152.83	152.78	152.82	111800.0
2007-05-22 08:00:00	SPY	ETF	152.75	152.89	152.75	152.87	804400.0
2007-05-22 08:30:00	SPY	ETF	152.87	152.87	152.76	152.79	199500.0
2007-05-22 09:00:00	SPY	ETF	152.78	152.85	152.71	152.71	682065.0
2007-05-22 09:30:00	SPY	ETF	152.7	152.8	152.45	152.5885	9977825.0
2007-05-22 10:00:00	SPY	ETF	152.59	152.81	152.43	152.72	7336202.0
2007-05-22 10:30:00	SPY	ETF	152.72	152.79	152.52	152.67	6236793.0
2007-05-22 11:00:00	SPY	ETF	152.67	152.72	152.53	152.72	2966300.0
2007-05-22 11:30:00	SPY	ETF	152.72	152.73	152.4	152.49	4577000.0
2007-05-22 12:00:00	SPY	ETF	152.49	152.69	152.44	152.65	2898299.0
2007-05-22 12:30:00	SPY	ETF	152.64	152.98	152.62	152.94	8006096.0
2007-05-22 13:00:00	SPY	ETF	152.94	153.02	152.8	152.87	4055010.0
2007-05-22 13:30:00	SPY	ETF	152.86	153.15	152.86	152.97	4164107.0
2007-05-22 14:00:00	SPY	ETF	152.98	153.16	152.94	153.0	4486416.0
2007-05-22 14:30:00	SPY	ETF	153.0	153.11	152.87	152.97	5364150.0
2007-05-22 15:00:00	SPY	ETF	152.97	153.04	152.73	152.78	6810126.0
2007-05-22 15:30:00	SPY	ETF	152.78	152.87	152.55	152.6	7559898.0
2007-05-22 16:00:00	SPY	ETF	152.61	152.67	152.37	152.4	3136700.0
2007-05-22 16:30:00	SPY	ETF	152.4	152.44	152.37	152.39	997700.0
2007-05-22 17:00:00	SPY	ETF	152.39	152.42	152.37	152.39	11200.0
2007-05-22 17:30:00	SPY	ETF	152.44	152.44	152.38	152.38	4300.0
2007-05-22 18:00:00	SPY	ETF	152.43	152.45	152.43	152.45	3000.0
2007-05-22 18:30:00	SPY	ETF	152.43	152.65	152.43	152.65	98100.0
2007-05-22 19:00:00	SPY	ETF	152.46	152.46	152.46	152.46	100.0
2007-05-22 19:30:00	SPY	ETF	152.45	152.45	152.42	152.43	29700.0
2007-05-22 07:30:00	QQQ	ETF	47.1	47.11	47.09	47.11	5100.0
2007-05-22 08:00:00	QQQ	ETF	47.09	47.12	47.09	47.11	254871.0
2007-05-22 08:30:00	QQQ	ETF	47.1	47.12	47.06	47.06	179278.0
2007-05-22 09:00:00	QQQ	ETF	47.06	47.09	47.03	47.05	269321.0
2007-05-22 09:30:00	QQQ	ETF	47.04	47.11	46.94	46.983	13967554.0
2007-05-22 10:00:00	QQQ	ETF	46.99	47.05	46.87	47.0	11819645.0
2007-05-22 10:30:00	QQQ	ETF	46.99	47.06	46.94	47.0	6922755.0
2007-05-22 11:00:00	QQQ	ETF	47.0	47.02	46.93	47.02	4411212.0
2007-05-22 11:30:00	QQQ	ETF	47.02	47.04	46.9	46.927	3294211.0
2007-05-22 12:00:00	QQQ	ETF	46.92	47.03	46.91	47.01	1800077.0
2007-05-22 12:30:00	QQQ	ETF	47.02	47.14	47.0	47.13	5565922.0
2007-05-22 13:00:00	QQQ	ETF	47.13	47.17	47.08	47.093	5379423.0
2007-05-22 13:30:00	QQQ	ETF	47.1	47.2	47.1	47.15	4809099.0
2007-05-22 14:00:00	QQQ	ETF	47.14	47.24	47.13	47.19	8048822.0
2007-05-22 14:30:00	QQQ	ETF	47.19	47.28	47.19	47.2474	8117179.0
2007-05-22 15:00:00	QQQ	ETF	47.24	47.26	47.11	47.1494	9395190.0
2007-05-22 15:30:00	QQQ	ETF	47.14	47.2	47.096	47.14	8099972.0
2007-05-22 16:00:00	QQQ	ETF	47.13	47.18	47.0	47.05	3310850.0
2007-05-22 16:30:00	QQQ	ETF	47.05	47.14	47.05	47.07	780970.0
2007-05-22 17:00:00	QQQ	ETF	47.07	47.07	47.04	47.04	10383.0
2007-05-22 17:30:00	QQQ	ETF	47.07	47.07	47.05	47.05	589.0
2007-05-22 18:00:00	QQQ	ETF	47.05	47.06	47.05	47.06	12900.0
2007-05-22 18:30:00	QQQ	ETF	47.06	47.06	47.04	47.05	89085.0
2007-05-22 19:00:00	QQQ	ETF	47.05	47.05	47.05	47.05	420.0

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

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