PREVIEW / etf_30min / 2009-08-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-10.parquet
  size:    226 KB
  rows:    7,420

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-08-10 04:30:00	SPY	ETF	101.01	101.01	101.01	101.01	2000.0
2009-08-10 05:00:00	SPY	ETF	101.02	101.04	101.02	101.04	400.0
2009-08-10 05:30:00	SPY	ETF	100.98	100.98	100.98	100.98	200.0
2009-08-10 06:00:00	SPY	ETF	100.93	100.97	100.92	100.92	6100.0
2009-08-10 06:30:00	SPY	ETF	100.88	100.88	100.88	100.88	100.0
2009-08-10 07:00:00	SPY	ETF	100.9	100.9	100.65	100.75	139900.0
2009-08-10 07:30:00	SPY	ETF	100.75	100.85	100.73	100.85	384262.0
2009-08-10 08:00:00	SPY	ETF	100.86	101.0	100.71	100.72	1709703.0
2009-08-10 08:30:00	SPY	ETF	100.72	100.77	100.52	100.68	640541.0
2009-08-10 09:00:00	SPY	ETF	100.69	100.8	100.67	100.79	1112553.0
2009-08-10 09:30:00	SPY	ETF	100.74	101.07	100.55	100.93	16289737.0
2009-08-10 10:00:00	SPY	ETF	100.92	101.07	100.75	101.06	11076862.0
2009-08-10 10:30:00	SPY	ETF	101.06	101.22	100.97	101.1	7105925.0
2009-08-10 11:00:00	SPY	ETF	101.1	101.22	100.91	100.95	7582031.0
2009-08-10 11:30:00	SPY	ETF	100.96	101.1001	100.88	100.95	4728581.0
2009-08-10 12:00:00	SPY	ETF	100.96	101.06	100.8	100.81	3582905.0
2009-08-10 12:30:00	SPY	ETF	100.8	100.82	100.68	100.72	5727614.0
2009-08-10 13:00:00	SPY	ETF	100.72	100.72	100.41	100.52	14985863.0
2009-08-10 13:30:00	SPY	ETF	100.52	100.73	100.48	100.54	5914959.0
2009-08-10 14:00:00	SPY	ETF	100.54	100.59	100.27	100.45	7518835.0
2009-08-10 14:30:00	SPY	ETF	100.45	100.61	100.4	100.6	4988461.0
2009-08-10 15:00:00	SPY	ETF	100.6	100.78	100.5	100.69	12768257.0
2009-08-10 15:30:00	SPY	ETF	100.7	100.99	100.61	100.96	17474439.0
2009-08-10 16:00:00	SPY	ETF	100.96	101.23	100.91	101.16	6129361.0
2009-08-10 16:30:00	SPY	ETF	101.15	101.15	101.07	101.1	485073.0
2009-08-10 17:00:00	SPY	ETF	101.12	101.15	101.09	101.13	118024.0
2009-08-10 17:30:00	SPY	ETF	101.13	101.18	101.12	101.12	63188.0
2009-08-10 18:00:00	SPY	ETF	101.1	101.1	101.01	101.01	112215.0
2009-08-10 18:30:00	SPY	ETF	101.02	101.05	101.0	101.03	18350.0
2009-08-10 19:00:00	SPY	ETF	101.01	101.03	101.01	101.02	6535.0
2009-08-10 19:30:00	SPY	ETF	101.02	101.03	101.0	101.03	51452.0
2009-08-10 05:30:00	QQQ	ETF	39.77	39.78	39.77	39.78	3515.0
2009-08-10 06:30:00	QQQ	ETF	39.71	39.71	39.7	39.7	5200.0
2009-08-10 07:00:00	QQQ	ETF	39.66	39.66	39.61	39.66	24927.0
2009-08-10 07:30:00	QQQ	ETF	39.67	39.78	39.67	39.78	906613.0
2009-08-10 08:00:00	QQQ	ETF	39.8	39.82	39.7	39.7	1733667.0
2009-08-10 08:30:00	QQQ	ETF	39.69	39.71	39.64	39.71	177447.0
2009-08-10 09:00:00	QQQ	ETF	39.71	39.77	39.71	39.74	232238.0
2009-08-10 09:30:00	QQQ	ETF	39.73	39.85	39.58	39.7799	12133437.0
2009-08-10 10:00:00	QQQ	ETF	39.77	39.81	39.65	39.799	6474129.0
2009-08-10 10:30:00	QQQ	ETF	39.7999	39.82	39.7199	39.7695	3529978.0
2009-08-10 11:00:00	QQQ	ETF	39.76	39.81	39.65	39.67	4473937.0
2009-08-10 11:30:00	QQQ	ETF	39.66	39.7	39.6	39.61	2296527.0
2009-08-10 12:00:00	QQQ	ETF	39.61	39.67	39.54	39.5401	2160724.0
2009-08-10 12:30:00	QQQ	ETF	39.54	39.55	39.44	39.49	6321366.0
2009-08-10 13:00:00	QQQ	ETF	39.48	39.49	39.39	39.45	6402573.0
2009-08-10 13:30:00	QQQ	ETF	39.4583	39.56	39.44	39.48	4360179.0
2009-08-10 14:00:00	QQQ	ETF	39.49	39.49	39.34	39.4301	4489409.0
2009-08-10 14:30:00	QQQ	ETF	39.44	39.49	39.39	39.4701	3276030.0
2009-08-10 15:00:00	QQQ	ETF	39.48	39.5899	39.48	39.5501	6105886.0

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

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