PREVIEW / stock_5min / 2007-09-17

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-09-17.parquet
  size:    3.9 MB
  rows:    289,521
  symbols: 3,102

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
2007-09-17 09:30:00	AAPL	Stock	4.9639	4.9929	4.9586	4.9807	31782688.0
2007-09-17 09:35:00	AAPL	Stock	4.9807	5.0171	4.976	5.015	36013992.0
2007-09-17 09:40:00	AAPL	Stock	5.015	5.0211	5.0021	5.0096	24914764.0
2007-09-17 09:45:00	AAPL	Stock	5.01	5.0125	5.0007	5.0071	18004252.0
2007-09-17 09:50:00	AAPL	Stock	5.0064	5.0079	4.9861	4.9968	20580336.0
2007-09-17 09:55:00	AAPL	Stock	4.9971	5.0061	4.9925	4.9968	13527892.0
2007-09-17 10:00:00	AAPL	Stock	4.9968	5.0014	4.975	4.9789	18621624.0
2007-09-17 10:05:00	AAPL	Stock	4.9786	4.9914	4.9761	4.9889	16200520.0
2007-09-17 10:10:00	AAPL	Stock	4.9889	5.0036	4.9889	5.0007	14535276.0
2007-09-17 10:15:00	AAPL	Stock	5.0002	5.0089	4.9904	4.9946	15332940.0
2007-09-17 10:20:00	AAPL	Stock	4.9946	4.9954	4.9786	4.9789	10743124.0
2007-09-17 10:25:00	AAPL	Stock	4.9786	4.98	4.9661	4.9714	17387608.0
2007-09-17 10:30:00	AAPL	Stock	4.9718	4.9746	4.9575	4.9629	19064500.0
2007-09-17 10:35:00	AAPL	Stock	4.9621	4.9639	4.9459	4.9586	24066056.0
2007-09-17 10:40:00	AAPL	Stock	4.9589	4.9693	4.9543	4.9646	12866812.0
2007-09-17 10:45:00	AAPL	Stock	4.9643	4.9654	4.9586	4.9604	9584316.0
2007-09-17 10:50:00	AAPL	Stock	4.9604	4.9636	4.9496	4.9611	10772020.0
2007-09-17 10:55:00	AAPL	Stock	4.9614	4.9643	4.9554	4.9596	5787208.0
2007-09-17 11:00:00	AAPL	Stock	4.9594	4.9704	4.9589	4.9677	7408352.0
2007-09-17 11:05:00	AAPL	Stock	4.9671	4.9711	4.9593	4.9611	6808032.0
2007-09-17 11:10:00	AAPL	Stock	4.9607	4.9636	4.9575	4.9618	4288508.0
2007-09-17 11:15:00	AAPL	Stock	4.9616	4.9618	4.9471	4.9529	9156056.0
2007-09-17 11:20:00	AAPL	Stock	4.9529	4.9546	4.9421	4.9446	9619540.0
2007-09-17 11:25:00	AAPL	Stock	4.9457	4.9511	4.9375	4.9429	7217448.0
2007-09-17 11:30:00	AAPL	Stock	4.9425	4.9425	4.9357	4.9371	8227800.0
2007-09-17 11:35:00	AAPL	Stock	4.9379	4.9457	4.9375	4.9386	5166140.0
2007-09-17 11:40:00	AAPL	Stock	4.9379	4.9411	4.9286	4.9299	12338424.0
2007-09-17 11:45:00	AAPL	Stock	4.9296	4.9354	4.9232	4.9271	8615628.0
2007-09-17 11:50:00	AAPL	Stock	4.9268	4.9278	4.9143	4.9257	10901548.0
2007-09-17 11:55:00	AAPL	Stock	4.9257	4.9329	4.9214	4.9314	6801816.0
2007-09-17 12:00:00	AAPL	Stock	4.9314	4.9375	4.9282	4.934	6625080.0
2007-09-17 12:05:00	AAPL	Stock	4.9339	4.9361	4.9229	4.9275	5590928.0
2007-09-17 12:10:00	AAPL	Stock	4.9275	4.9279	4.9193	4.9261	7942788.0
2007-09-17 12:15:00	AAPL	Stock	4.9261	4.9321	4.9218	4.925	7254576.0
2007-09-17 12:20:00	AAPL	Stock	4.925	4.9261	4.9207	4.9246	3266956.0
2007-09-17 12:25:00	AAPL	Stock	4.9243	4.9336	4.9236	4.9296	4166568.0
2007-09-17 12:30:00	AAPL	Stock	4.9289	4.9343	4.9254	4.9336	3360784.0
2007-09-17 12:35:00	AAPL	Stock	4.9325	4.9421	4.9325	4.9393	8543472.0
2007-09-17 12:40:00	AAPL	Stock	4.9393	4.94	4.9314	4.9318	3080728.0
2007-09-17 12:45:00	AAPL	Stock	4.9314	4.9346	4.9279	4.9339	5841500.0
2007-09-17 12:50:00	AAPL	Stock	4.9343	4.9414	4.9321	4.9361	5086788.0
2007-09-17 12:55:00	AAPL	Stock	4.9357	4.9461	4.935	4.9407	5271756.0
2007-09-17 13:00:00	AAPL	Stock	4.9407	4.9457	4.9393	4.9454	4490696.0
2007-09-17 13:05:00	AAPL	Stock	4.945	4.9479	4.94	4.9436	6189596.0
2007-09-17 13:10:00	AAPL	Stock	4.9439	4.9496	4.9375	4.9471	5005476.0
2007-09-17 13:15:00	AAPL	Stock	4.9475	4.9543	4.9457	4.9518	7435456.0
2007-09-17 13:20:00	AAPL	Stock	4.9514	4.9546	4.9446	4.9468	3905636.0
2007-09-17 13:25:00	AAPL	Stock	4.9468	4.9529	4.9468	4.9514	3673628.0
2007-09-17 13:30:00	AAPL	Stock	4.9511	4.9525	4.9432	4.9432	4586288.0
2007-09-17 13:35:00	AAPL	Stock	4.9432	4.9486	4.9393	4.9454	5310396.0

> showing 50 of 289,521 rows — these rows as CSV

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