PREVIEW / etf_30min / 2010-02-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-26.parquet
  size:    237 KB
  rows:    8,073

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
2010-02-26 04:30:00	SPY	ETF	110.97	110.97	110.97	110.97	100.0
2010-02-26 05:00:00	SPY	ETF	111.03	111.06	110.99	111.06	1900.0
2010-02-26 05:30:00	SPY	ETF	111.08	111.08	111.05	111.05	800.0
2010-02-26 06:00:00	SPY	ETF	111.02	111.02	110.92	110.92	7300.0
2010-02-26 06:30:00	SPY	ETF	110.9	110.9	110.75	110.81	13900.0
2010-02-26 07:00:00	SPY	ETF	110.86	111.05	110.85	110.9	199697.0
2010-02-26 07:30:00	SPY	ETF	110.9	110.94	110.69	110.7	155299.0
2010-02-26 08:00:00	SPY	ETF	110.73	111.11	110.67	110.82	539912.0
2010-02-26 08:30:00	SPY	ETF	110.84	110.94	110.54	110.86	3591395.0
2010-02-26 09:00:00	SPY	ETF	110.86	110.87	110.73	110.77	761064.0
2010-02-26 09:30:00	SPY	ETF	110.77	110.83	110.36	110.5	27336295.0
2010-02-26 10:00:00	SPY	ETF	110.46	110.77	110.11	110.72	23852186.0
2010-02-26 10:30:00	SPY	ETF	110.72	111.07	110.67	110.75	16300124.0
2010-02-26 11:00:00	SPY	ETF	110.76	110.97	110.69	110.81	10609317.0
2010-02-26 11:30:00	SPY	ETF	110.81	111.0	110.72	110.76	7737809.0
2010-02-26 12:00:00	SPY	ETF	110.76	110.77	110.57	110.68	8126480.0
2010-02-26 12:30:00	SPY	ETF	110.678	110.72	110.44	110.61	9376363.0
2010-02-26 13:00:00	SPY	ETF	110.6	110.81	110.52	110.8	4748830.0
2010-02-26 13:30:00	SPY	ETF	110.8	110.97	110.66	110.9099	7198561.0
2010-02-26 14:00:00	SPY	ETF	110.91	110.94	110.76	110.88	4991344.0
2010-02-26 14:30:00	SPY	ETF	110.885	111.0409	110.8	111.0	4931793.0
2010-02-26 15:00:00	SPY	ETF	111.0	111.12	110.86	111.0	7755812.0
2010-02-26 15:30:00	SPY	ETF	111.005	111.08	110.74	110.75	22864639.0
2010-02-26 16:00:00	SPY	ETF	110.75	111.06	110.43	110.99	8922996.0
2010-02-26 16:30:00	SPY	ETF	110.99	111.07	110.97	111.04	1497619.0
2010-02-26 17:00:00	SPY	ETF	111.04	111.15	111.0	111.11	298335.0
2010-02-26 17:30:00	SPY	ETF	111.11	111.16	111.11	111.14	120015.0
2010-02-26 18:00:00	SPY	ETF	111.12	111.14	111.09	111.09	28200.0
2010-02-26 18:30:00	SPY	ETF	111.1	111.12	111.08	111.12	40400.0
2010-02-26 19:00:00	SPY	ETF	111.1	111.18	111.09	111.16	31807.0
2010-02-26 19:30:00	SPY	ETF	111.15	111.2	111.13	111.14	63596.0
2010-02-26 04:00:00	QQQ	ETF	44.69	44.69	44.69	44.69	600.0
2010-02-26 04:30:00	QQQ	ETF	44.7	44.7	44.7	44.7	1000.0
2010-02-26 06:30:00	QQQ	ETF	44.67	44.67	44.67	44.67	200.0
2010-02-26 07:00:00	QQQ	ETF	44.66	44.69	44.66	44.69	5600.0
2010-02-26 07:30:00	QQQ	ETF	44.67	44.67	44.6	44.6	17669.0
2010-02-26 08:00:00	QQQ	ETF	44.61	44.75	44.55	44.62	734043.0
2010-02-26 08:30:00	QQQ	ETF	44.62	44.66	44.5	44.64	1928427.0
2010-02-26 09:00:00	QQQ	ETF	44.64	44.66	44.57	44.61	233956.0
2010-02-26 09:30:00	QQQ	ETF	44.6	44.6	44.4	44.49	13681717.0
2010-02-26 10:00:00	QQQ	ETF	44.49	44.76	44.4	44.72	11032823.0
2010-02-26 10:30:00	QQQ	ETF	44.72	44.85	44.66	44.69	7235380.0
2010-02-26 11:00:00	QQQ	ETF	44.68	44.7724	44.64	44.74	3081133.0
2010-02-26 11:30:00	QQQ	ETF	44.73	44.825	44.7	44.72	3091943.0
2010-02-26 12:00:00	QQQ	ETF	44.73	44.74	44.62	44.695	3223075.0
2010-02-26 12:30:00	QQQ	ETF	44.695	44.77	44.65	44.72	4273018.0
2010-02-26 13:00:00	QQQ	ETF	44.72	44.77	44.6899	44.77	1491096.0
2010-02-26 13:30:00	QQQ	ETF	44.7699	44.83	44.71	44.8099	2586155.0
2010-02-26 14:00:00	QQQ	ETF	44.8	44.82	44.75	44.8	1684877.0
2010-02-26 14:30:00	QQQ	ETF	44.8	44.82	44.76	44.82	1164172.0

> showing 50 of 8,073 rows — these rows as CSV

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