PREVIEW / stock_5min / 2010-07-19

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-19.parquet
  size:    4.5 MB
  rows:    315,831
  symbols: 3,449

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-07-19 04:00:00	AAPL	Stock	8.9461	8.9721	8.9461	8.9721	8400.0
2010-07-19 05:30:00	AAPL	Stock	8.9986	8.9996	8.9986	8.9996	8400.0
2010-07-19 05:55:00	AAPL	Stock	8.9961	8.9961	8.9961	8.9961	5320.0
2010-07-19 06:30:00	AAPL	Stock	8.9725	8.9725	8.9725	8.9725	11200.0
2010-07-19 06:35:00	AAPL	Stock	8.9725	8.9725	8.9725	8.9725	7560.0
2010-07-19 06:40:00	AAPL	Stock	8.9814	8.9821	8.9814	8.9821	19320.0
2010-07-19 06:45:00	AAPL	Stock	8.9946	8.9961	8.9946	8.9961	45052.0
2010-07-19 06:50:00	AAPL	Stock	8.9961	8.9961	8.9961	8.9961	5600.0
2010-07-19 06:55:00	AAPL	Stock	9.0054	9.0175	9.0054	9.0175	21000.0
2010-07-19 07:00:00	AAPL	Stock	8.9771	8.9771	8.9375	8.9643	80500.0
2010-07-19 07:05:00	AAPL	Stock	8.9643	8.9704	8.9639	8.9643	117600.0
2010-07-19 07:10:00	AAPL	Stock	8.9554	8.9554	8.9464	8.9507	75628.0
2010-07-19 07:15:00	AAPL	Stock	8.9529	8.9536	8.9375	8.9446	245000.0
2010-07-19 07:20:00	AAPL	Stock	8.9357	8.9357	8.8893	8.8936	324464.0
2010-07-19 07:25:00	AAPL	Stock	8.8936	8.9036	8.8893	8.9036	64820.0
2010-07-19 07:30:00	AAPL	Stock	8.9036	8.9107	8.895	8.8996	131600.0
2010-07-19 07:35:00	AAPL	Stock	8.8996	8.9032	8.8964	8.8964	198800.0
2010-07-19 07:40:00	AAPL	Stock	8.8996	8.8996	8.8925	8.8925	603596.0
2010-07-19 07:45:00	AAPL	Stock	8.8964	8.9064	8.8807	8.8807	1505784.0
2010-07-19 07:50:00	AAPL	Stock	8.8868	8.8996	8.8836	8.8979	70868.0
2010-07-19 07:55:00	AAPL	Stock	8.8979	8.9061	8.8911	8.8932	160944.0
2010-07-19 08:00:00	AAPL	Stock	8.9043	8.91	8.8821	8.8839	436408.0
2010-07-19 08:05:00	AAPL	Stock	8.8911	8.8929	8.8821	8.8843	453656.0
2010-07-19 08:10:00	AAPL	Stock	8.8929	8.9289	8.8893	8.9289	293552.0
2010-07-19 08:15:00	AAPL	Stock	8.9289	8.9311	8.9214	8.9243	362292.0
2010-07-19 08:20:00	AAPL	Stock	8.9268	8.9286	8.9225	8.9271	166236.0
2010-07-19 08:25:00	AAPL	Stock	8.9286	8.9511	8.9271	8.9396	545384.0
2010-07-19 08:30:00	AAPL	Stock	8.9443	8.9446	8.9289	8.9321	508452.0
2010-07-19 08:35:00	AAPL	Stock	8.9321	8.9339	8.9175	8.9339	673820.0
2010-07-19 08:40:00	AAPL	Stock	8.9339	8.9393	8.9286	8.9311	396340.0
2010-07-19 08:45:00	AAPL	Stock	8.9339	8.9339	8.9246	8.9286	310072.0
2010-07-19 08:50:00	AAPL	Stock	8.925	8.9325	8.9229	8.9286	366212.0
2010-07-19 08:55:00	AAPL	Stock	8.9286	8.9357	8.9286	8.9339	448868.0
2010-07-19 09:00:00	AAPL	Stock	8.9339	8.9371	8.9289	8.9332	525700.0
2010-07-19 09:05:00	AAPL	Stock	8.9325	8.9354	8.9275	8.9279	352828.0
2010-07-19 09:10:00	AAPL	Stock	8.9275	8.9321	8.9271	8.9289	162400.0
2010-07-19 09:15:00	AAPL	Stock	8.9311	8.9314	8.9271	8.9286	114800.0
2010-07-19 09:20:00	AAPL	Stock	8.9286	8.9286	8.9196	8.9214	343756.0
2010-07-19 09:25:00	AAPL	Stock	8.9196	8.9271	8.9143	8.9193	538048.0
2010-07-19 09:30:00	AAPL	Stock	8.9243	8.9243	8.875	8.8799	32255888.0
2010-07-19 09:35:00	AAPL	Stock	8.8797	8.8854	8.8164	8.8227	31642968.0
2010-07-19 09:40:00	AAPL	Stock	8.8239	8.8525	8.8221	8.825	18153828.0
2010-07-19 09:45:00	AAPL	Stock	8.8264	8.8564	8.8164	8.8261	21275324.0
2010-07-19 09:50:00	AAPL	Stock	8.8275	8.9143	8.7864	8.7929	32756948.0
2010-07-19 09:55:00	AAPL	Stock	8.7896	8.8929	8.7393	8.75	38559080.0
2010-07-19 10:00:00	AAPL	Stock	8.75	8.7696	8.7411	8.7564	16719948.0
2010-07-19 10:05:00	AAPL	Stock	8.7575	8.8571	8.725	8.7307	24238088.0
2010-07-19 10:10:00	AAPL	Stock	8.7307	8.7346	8.6954	8.7036	27554436.0
2010-07-19 10:15:00	AAPL	Stock	8.7025	8.7268	8.6982	8.7191	17865260.0
2010-07-19 10:20:00	AAPL	Stock	8.7211	8.7339	8.6768	8.6804	21083748.0

> showing 50 of 315,831 rows — these rows as CSV

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