PREVIEW / stock_5min / 2011-01-04

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-01-04.parquet
  size:    5.0 MB
  rows:    339,868
  symbols: 3,506

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
2011-01-04 05:00:00	AAPL	Stock	11.7964	11.8332	11.7964	11.8332	5600.0
2011-01-04 06:50:00	AAPL	Stock	11.8157	11.8157	11.8157	11.8157	2800.0
2011-01-04 06:55:00	AAPL	Stock	11.8225	11.8243	11.8225	11.8243	11200.0
2011-01-04 07:00:00	AAPL	Stock	11.825	11.8464	11.825	11.8464	182000.0
2011-01-04 07:05:00	AAPL	Stock	11.8482	11.8571	11.8482	11.8561	19600.0
2011-01-04 07:10:00	AAPL	Stock	11.8571	11.8571	11.8482	11.8507	470120.0
2011-01-04 07:15:00	AAPL	Stock	11.8568	11.8679	11.8568	11.8643	163632.0
2011-01-04 07:20:00	AAPL	Stock	11.8679	11.8746	11.8571	11.8682	84700.0
2011-01-04 07:25:00	AAPL	Stock	11.8679	11.8786	11.8679	11.8786	134400.0
2011-01-04 07:30:00	AAPL	Stock	11.8768	11.8875	11.875	11.8771	96600.0
2011-01-04 07:35:00	AAPL	Stock	11.8771	11.8771	11.8664	11.8664	70000.0
2011-01-04 07:40:00	AAPL	Stock	11.8614	11.8614	11.8582	11.8586	33600.0
2011-01-04 07:45:00	AAPL	Stock	11.8671	11.8679	11.8607	11.8679	36400.0
2011-01-04 07:50:00	AAPL	Stock	11.8696	11.8711	11.8679	11.8679	31360.0
2011-01-04 07:55:00	AAPL	Stock	11.8661	11.8714	11.8657	11.8682	88396.0
2011-01-04 08:00:00	AAPL	Stock	11.8654	11.8732	11.8589	11.8636	650552.0
2011-01-04 08:05:00	AAPL	Stock	11.8593	11.86	11.8489	11.8596	269136.0
2011-01-04 08:10:00	AAPL	Stock	11.8607	11.8657	11.8607	11.8629	117740.0
2011-01-04 08:15:00	AAPL	Stock	11.8643	11.8968	11.8643	11.8904	630672.0
2011-01-04 08:20:00	AAPL	Stock	11.8911	11.8929	11.8768	11.8768	437668.0
2011-01-04 08:25:00	AAPL	Stock	11.8768	11.8818	11.875	11.875	101500.0
2011-01-04 08:30:00	AAPL	Stock	11.8771	11.8829	11.8761	11.8804	103600.0
2011-01-04 08:35:00	AAPL	Stock	11.8804	11.8821	11.8764	11.8764	123956.0
2011-01-04 08:40:00	AAPL	Stock	11.8779	11.8782	11.8736	11.8739	336896.0
2011-01-04 08:45:00	AAPL	Stock	11.8757	11.8771	11.8689	11.8714	262444.0
2011-01-04 08:50:00	AAPL	Stock	11.87	11.8707	11.8682	11.87	136696.0
2011-01-04 08:55:00	AAPL	Stock	11.8696	11.8764	11.8696	11.8739	213528.0
2011-01-04 09:00:00	AAPL	Stock	11.8736	11.8793	11.8729	11.875	479360.0
2011-01-04 09:05:00	AAPL	Stock	11.8757	11.8796	11.8746	11.875	381416.0
2011-01-04 09:10:00	AAPL	Stock	11.8771	11.8786	11.875	11.8768	86520.0
2011-01-04 09:15:00	AAPL	Stock	11.8768	11.8821	11.8718	11.875	371700.0
2011-01-04 09:20:00	AAPL	Stock	11.8779	11.8782	11.8707	11.8743	204848.0
2011-01-04 09:25:00	AAPL	Stock	11.8729	11.8779	11.8621	11.8739	434644.0
2011-01-04 09:30:00	AAPL	Stock	11.8736	11.8761	11.8429	11.8491	15764476.0
2011-01-04 09:35:00	AAPL	Stock	11.8489	11.8646	11.8486	11.8582	8380344.0
2011-01-04 09:40:00	AAPL	Stock	11.8575	11.8592	11.8125	11.8125	9738820.0
2011-01-04 09:45:00	AAPL	Stock	11.8132	11.8346	11.8089	11.8236	7683760.0
2011-01-04 09:50:00	AAPL	Stock	11.8243	11.84	11.8161	11.8218	7243040.0
2011-01-04 09:55:00	AAPL	Stock	11.82	11.8346	11.82	11.8282	3505656.0
2011-01-04 10:00:00	AAPL	Stock	11.8286	11.8393	11.8246	11.8346	5664680.0
2011-01-04 10:05:00	AAPL	Stock	11.8371	11.8421	11.8086	11.8182	6944588.0
2011-01-04 10:10:00	AAPL	Stock	11.8185	11.8246	11.8	11.8071	7118720.0
2011-01-04 10:15:00	AAPL	Stock	11.8043	11.8111	11.7957	11.81	4728444.0
2011-01-04 10:20:00	AAPL	Stock	11.8086	11.8296	11.8036	11.8271	4634868.0
2011-01-04 10:25:00	AAPL	Stock	11.827	11.8282	11.8079	11.8141	4085844.0
2011-01-04 10:30:00	AAPL	Stock	11.8139	11.8188	11.8093	11.8129	2420852.0
2011-01-04 10:35:00	AAPL	Stock	11.8118	11.8166	11.8054	11.8107	2643116.0
2011-01-04 10:40:00	AAPL	Stock	11.8096	11.8179	11.8054	11.8146	2728460.0
2011-01-04 10:45:00	AAPL	Stock	11.8168	11.8188	11.8071	11.8107	2555728.0
2011-01-04 10:50:00	AAPL	Stock	11.8104	11.8104	11.7929	11.7996	6333348.0

> showing 50 of 339,868 rows — these rows as CSV

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