PREVIEW / stock_30min / 2009-05-05

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-05.parquet
  size:    1.3 MB
  rows:    74,193
  symbols: 3,358

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-05-05 07:00:00	AAPL	Stock	4.69	4.69	4.6786	4.6857	104636.0
2009-05-05 07:30:00	AAPL	Stock	4.6868	4.6893	4.6857	4.6857	28000.0
2009-05-05 08:00:00	AAPL	Stock	4.7	4.7132	4.6964	4.7036	230776.0
2009-05-05 08:30:00	AAPL	Stock	4.7036	4.7139	4.6786	4.7068	949256.0
2009-05-05 09:00:00	AAPL	Stock	4.7018	4.7107	4.6954	4.7071	487368.0
2009-05-05 09:30:00	AAPL	Stock	4.7089	4.7414	4.6829	4.7161	64909152.0
2009-05-05 10:00:00	AAPL	Stock	4.7164	4.7339	4.7036	4.7161	38663072.0
2009-05-05 10:30:00	AAPL	Stock	4.7157	4.7275	4.6989	4.7004	29533056.0
2009-05-05 11:00:00	AAPL	Stock	4.6989	4.7196	4.6946	4.7157	19498752.0
2009-05-05 11:30:00	AAPL	Stock	4.715	4.7264	4.7136	4.7164	18001004.0
2009-05-05 12:00:00	AAPL	Stock	4.7164	4.7264	4.7111	4.7246	15193892.0
2009-05-05 12:30:00	AAPL	Stock	4.7246	4.7261	4.7089	4.7129	14880572.0
2009-05-05 13:00:00	AAPL	Stock	4.7129	4.725	4.7079	4.7125	19691056.0
2009-05-05 13:30:00	AAPL	Stock	4.7125	4.7375	4.7054	4.7332	32670540.0
2009-05-05 14:00:00	AAPL	Stock	4.7321	4.7332	4.7039	4.7068	27374508.0
2009-05-05 14:30:00	AAPL	Stock	4.7068	4.7196	4.6993	4.7068	23835728.0
2009-05-05 15:00:00	AAPL	Stock	4.7061	4.7314	4.7021	4.725	27116096.0
2009-05-05 15:30:00	AAPL	Stock	4.7254	4.745	4.7248	4.7393	49819028.0
2009-05-05 16:00:00	AAPL	Stock	4.7396	4.7411	4.7054	4.7181	8249444.0
2009-05-05 16:30:00	AAPL	Stock	4.7181	4.7429	4.7181	4.7396	599256.0
2009-05-05 17:00:00	AAPL	Stock	4.7357	4.7393	4.7357	4.7375	65800.0
2009-05-05 17:30:00	AAPL	Stock	4.7389	4.7411	4.7357	4.7411	63476.0
2009-05-05 18:00:00	AAPL	Stock	4.7396	4.7429	4.7396	4.7429	166964.0
2009-05-05 18:30:00	AAPL	Stock	4.7429	4.7439	4.7429	4.7432	83020.0
2009-05-05 19:00:00	AAPL	Stock	4.7439	4.7439	4.7432	4.7432	12460.0
2009-05-05 19:30:00	AAPL	Stock	4.7446	4.7446	4.7421	4.7446	48692.0
2009-05-05 06:00:00	MSFT	Stock	20.28	20.28	20.28	20.28	150.0
2009-05-05 06:30:00	MSFT	Stock	20.3	20.35	20.3	20.35	1950.0
2009-05-05 07:00:00	MSFT	Stock	20.3	20.38	20.3	20.3	4999.0
2009-05-05 07:30:00	MSFT	Stock	20.27	20.27	20.25	20.25	2100.0
2009-05-05 08:00:00	MSFT	Stock	20.2	20.28	20.11	20.19	10705.0
2009-05-05 08:30:00	MSFT	Stock	20.19	20.19	20.13	20.14	6436.0
2009-05-05 09:00:00	MSFT	Stock	20.13	20.18	20.13	20.13	3192.0
2009-05-05 09:30:00	MSFT	Stock	20.14	20.24	20.05	20.16	6131439.0
2009-05-05 10:00:00	MSFT	Stock	20.16	20.2	19.81	19.86	8858835.0
2009-05-05 10:30:00	MSFT	Stock	19.85	19.986	19.76	19.82	6210289.0
2009-05-05 11:00:00	MSFT	Stock	19.82	19.85	19.75	19.819	3283416.0
2009-05-05 11:30:00	MSFT	Stock	19.82	19.85	19.79	19.83	3851992.0
2009-05-05 12:00:00	MSFT	Stock	19.825	19.84	19.73	19.77	2923621.0
2009-05-05 12:30:00	MSFT	Stock	19.755	19.8	19.75	19.77	1873232.0
2009-05-05 13:00:00	MSFT	Stock	19.76	19.78	19.7	19.72	2107884.0
2009-05-05 13:30:00	MSFT	Stock	19.72	19.8	19.7	19.77	2346473.0
2009-05-05 14:00:00	MSFT	Stock	19.77	19.84	19.65	19.658	3285512.0
2009-05-05 14:30:00	MSFT	Stock	19.65	19.77	19.64	19.68	3721647.0
2009-05-05 15:00:00	MSFT	Stock	19.68	19.76	19.65	19.67	4207415.0
2009-05-05 15:30:00	MSFT	Stock	19.68	19.93	19.65	19.81	10199803.0
2009-05-05 16:00:00	MSFT	Stock	19.79	20.103	19.72	19.8	6352531.0
2009-05-05 16:30:00	MSFT	Stock	20.07	20.07	19.78	19.78	53894.0
2009-05-05 17:00:00	MSFT	Stock	19.8	19.82	19.8	19.8	10303.0
2009-05-05 17:30:00	MSFT	Stock	19.82	19.86	19.82	19.86	870.0

> showing 50 of 74,193 rows — these rows as CSV

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