PREVIEW / stock_5min / 2009-11-03

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-11-03.parquet
  size:    4.7 MB
  rows:    323,876
  symbols: 3,417

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-11-03 05:10:00	AAPL	Stock	6.715	6.715	6.715	6.715	5600.0
2009-11-03 06:05:00	AAPL	Stock	6.6661	6.6661	6.6661	6.6661	5600.0
2009-11-03 06:10:00	AAPL	Stock	6.6654	6.6654	6.6654	6.6654	5600.0
2009-11-03 06:15:00	AAPL	Stock	6.6611	6.6632	6.6607	6.6607	8400.0
2009-11-03 06:20:00	AAPL	Stock	6.6704	6.6804	6.6704	6.6804	39200.0
2009-11-03 06:30:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	2800.0
2009-11-03 06:35:00	AAPL	Stock	6.6836	6.6839	6.6836	6.6839	8400.0
2009-11-03 07:00:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	2800.0
2009-11-03 07:05:00	AAPL	Stock	6.6839	6.6839	6.6839	6.6839	22372.0
2009-11-03 07:10:00	AAPL	Stock	6.6921	6.6964	6.6921	6.6964	14000.0
2009-11-03 07:15:00	AAPL	Stock	6.7104	6.7104	6.705	6.705	5964.0
2009-11-03 07:30:00	AAPL	Stock	6.7068	6.7068	6.6829	6.6829	24892.0
2009-11-03 07:35:00	AAPL	Stock	6.6825	6.6946	6.6825	6.6946	17920.0
2009-11-03 07:45:00	AAPL	Stock	6.7029	6.7029	6.7029	6.7029	14000.0
2009-11-03 07:50:00	AAPL	Stock	6.7	6.7	6.7	6.7	11200.0
2009-11-03 07:55:00	AAPL	Stock	6.6946	6.6946	6.6904	6.6904	14000.0
2009-11-03 08:00:00	AAPL	Stock	6.7	6.7104	6.6896	6.7071	282380.0
2009-11-03 08:05:00	AAPL	Stock	6.7071	6.7193	6.7071	6.7107	148848.0
2009-11-03 08:10:00	AAPL	Stock	6.7136	6.7136	6.7	6.7	98364.0
2009-11-03 08:15:00	AAPL	Stock	6.7029	6.7071	6.7	6.7071	27804.0
2009-11-03 08:20:00	AAPL	Stock	6.7121	6.7136	6.7104	6.7104	42000.0
2009-11-03 08:25:00	AAPL	Stock	6.7136	6.7143	6.7107	6.7107	558936.0
2009-11-03 08:30:00	AAPL	Stock	6.7139	6.73	6.7111	6.73	65520.0
2009-11-03 08:35:00	AAPL	Stock	6.7279	6.7364	6.7179	6.7279	193480.0
2009-11-03 08:40:00	AAPL	Stock	6.7279	6.7279	6.7089	6.7143	174020.0
2009-11-03 08:45:00	AAPL	Stock	6.7143	6.7143	6.7112	6.7112	28420.0
2009-11-03 08:50:00	AAPL	Stock	6.7111	6.7111	6.7018	6.7018	87416.0
2009-11-03 08:55:00	AAPL	Stock	6.7079	6.7079	6.707	6.7071	19600.0
2009-11-03 09:00:00	AAPL	Stock	6.7011	6.7068	6.7007	6.7014	56000.0
2009-11-03 09:05:00	AAPL	Stock	6.7014	6.7079	6.7014	6.7068	108920.0
2009-11-03 09:10:00	AAPL	Stock	6.7086	6.7086	6.7007	6.7064	218344.0
2009-11-03 09:15:00	AAPL	Stock	6.7054	6.7079	6.7021	6.7079	72800.0
2009-11-03 09:20:00	AAPL	Stock	6.7046	6.7046	6.7021	6.7025	112000.0
2009-11-03 09:25:00	AAPL	Stock	6.7025	6.7143	6.6964	6.7132	646016.0
2009-11-03 09:30:00	AAPL	Stock	6.7132	6.7368	6.6868	6.7157	14855372.0
2009-11-03 09:35:00	AAPL	Stock	6.7157	6.7411	6.695	6.6986	12527676.0
2009-11-03 09:40:00	AAPL	Stock	6.6986	6.7182	6.6761	6.6857	14213500.0
2009-11-03 09:45:00	AAPL	Stock	6.6857	6.7061	6.6857	6.6893	8555540.0
2009-11-03 09:50:00	AAPL	Stock	6.6889	6.7261	6.6871	6.7118	9901332.0
2009-11-03 09:55:00	AAPL	Stock	6.7118	6.7411	6.6964	6.7354	10265948.0
2009-11-03 10:00:00	AAPL	Stock	6.7354	6.7579	6.7096	6.7564	13949544.0
2009-11-03 10:05:00	AAPL	Stock	6.7564	6.7686	6.7357	6.759	11195856.0
2009-11-03 10:10:00	AAPL	Stock	6.7593	6.7618	6.7211	6.7418	11101020.0
2009-11-03 10:15:00	AAPL	Stock	6.7411	6.7521	6.7161	6.7293	7495908.0
2009-11-03 10:20:00	AAPL	Stock	6.7293	6.7357	6.7175	6.7214	5813136.0
2009-11-03 10:25:00	AAPL	Stock	6.7207	6.7236	6.6982	6.7018	8266888.0
2009-11-03 10:30:00	AAPL	Stock	6.7021	6.7257	6.7004	6.7246	5519892.0
2009-11-03 10:35:00	AAPL	Stock	6.7228	6.7257	6.6975	6.7061	4480672.0
2009-11-03 10:40:00	AAPL	Stock	6.7079	6.7286	6.7071	6.7268	4705792.0
2009-11-03 10:45:00	AAPL	Stock	6.7286	6.7321	6.715	6.7257	4095112.0

> showing 50 of 323,876 rows — these rows as CSV

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