PREVIEW / etf_30min / 2009-07-24

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-24.parquet
  size:    228 KB
  rows:    7,477

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
2009-07-24 04:00:00	SPY	ETF	97.5	97.81	97.5	97.72	24674.0
2009-07-24 04:30:00	SPY	ETF	97.7	97.7	97.53	97.53	26350.0
2009-07-24 05:00:00	SPY	ETF	97.48	97.53	97.48	97.53	1000.0
2009-07-24 05:30:00	SPY	ETF	97.48	97.64	97.48	97.64	20300.0
2009-07-24 06:00:00	SPY	ETF	97.61	97.65	97.53	97.53	18348.0
2009-07-24 06:30:00	SPY	ETF	97.48	97.6	97.47	97.6	202567.0
2009-07-24 07:00:00	SPY	ETF	97.56	97.64	97.49	97.53	311706.0
2009-07-24 07:30:00	SPY	ETF	97.58	97.58	97.47	97.57	717825.0
2009-07-24 08:00:00	SPY	ETF	97.56	97.63	97.26	97.3	1279671.0
2009-07-24 08:30:00	SPY	ETF	97.3	97.42	97.15	97.18	1401521.0
2009-07-24 09:00:00	SPY	ETF	97.18	97.24	97.1	97.19	1212561.0
2009-07-24 09:30:00	SPY	ETF	97.2	97.64	96.92	96.97	20819382.0
2009-07-24 10:00:00	SPY	ETF	96.98	97.21	96.85	97.2	14877816.0
2009-07-24 10:30:00	SPY	ETF	97.2	97.24	96.7	96.8	12732894.0
2009-07-24 11:00:00	SPY	ETF	96.8	97.16	96.69	97.1516	10629366.0
2009-07-24 11:30:00	SPY	ETF	97.16	97.52	96.95	97.46	10639645.0
2009-07-24 12:00:00	SPY	ETF	97.45	97.54	97.34	97.4	6875143.0
2009-07-24 12:30:00	SPY	ETF	97.4	97.53	97.315	97.38	5386854.0
2009-07-24 13:00:00	SPY	ETF	97.38	97.58	97.33	97.52	5236222.0
2009-07-24 13:30:00	SPY	ETF	97.53	97.9	97.53	97.76	12059228.0
2009-07-24 14:00:00	SPY	ETF	97.76	97.94	97.65	97.7	9001380.0
2009-07-24 14:30:00	SPY	ETF	97.7	97.9	97.63	97.74	7290506.0
2009-07-24 15:00:00	SPY	ETF	97.75	97.94	97.68	97.89	6865351.0
2009-07-24 15:30:00	SPY	ETF	97.89	98.14	97.7	98.06	16868666.0
2009-07-24 16:00:00	SPY	ETF	98.07	98.3	97.1494	98.24	8361782.0
2009-07-24 16:30:00	SPY	ETF	98.24	98.35	98.19	98.3	176816.0
2009-07-24 17:00:00	SPY	ETF	98.3	98.38	98.24	98.36	104550.0
2009-07-24 17:30:00	SPY	ETF	98.36	98.39	97.2	98.35	156414.0
2009-07-24 18:00:00	SPY	ETF	98.34	98.4	98.04	98.29	89530.0
2009-07-24 18:30:00	SPY	ETF	98.29	98.34	98.26	98.3	5903.0
2009-07-24 19:00:00	SPY	ETF	98.31	98.34	98.26	98.33	6253.0
2009-07-24 19:30:00	SPY	ETF	98.34	98.42	98.34	98.4	36453.0
2009-07-24 04:00:00	QQQ	ETF	39.1	39.2	39.1	39.1	16149.0
2009-07-24 04:30:00	QQQ	ETF	39.14	39.14	39.08	39.08	700.0
2009-07-24 05:00:00	QQQ	ETF	39.01	39.01	39.01	39.01	1990.0
2009-07-24 05:30:00	QQQ	ETF	39.01	39.01	39.01	39.01	500.0
2009-07-24 06:00:00	QQQ	ETF	39.09	39.09	39.09	39.09	812.0
2009-07-24 06:30:00	QQQ	ETF	39.06	39.07	39.02	39.07	14678.0
2009-07-24 07:00:00	QQQ	ETF	39.06	39.06	38.96	38.96	502861.0
2009-07-24 07:30:00	QQQ	ETF	38.97	39.01	38.96	39.01	127664.0
2009-07-24 08:00:00	QQQ	ETF	39.01	39.05	38.89	38.93	815723.0
2009-07-24 08:30:00	QQQ	ETF	38.92	38.98	38.79	38.82	1151165.0
2009-07-24 09:00:00	QQQ	ETF	38.82	38.93	38.8	38.92	834082.0
2009-07-24 09:30:00	QQQ	ETF	38.93	39.18	38.7799	38.82	21311346.0
2009-07-24 10:00:00	QQQ	ETF	38.83	39.0	38.78	39.0	7247426.0
2009-07-24 10:30:00	QQQ	ETF	39.0	39.04	38.84	38.88	8222781.0
2009-07-24 11:00:00	QQQ	ETF	38.88	39.07	38.85	39.03	6176471.0
2009-07-24 11:30:00	QQQ	ETF	39.03	39.15	39.0	39.15	4944340.0
2009-07-24 12:00:00	QQQ	ETF	39.15	39.2	39.07	39.1	7973717.0
2009-07-24 12:30:00	QQQ	ETF	39.096	39.1599	39.06	39.0899	2301403.0

> showing 50 of 7,477 rows — these rows as CSV

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