PREVIEW / stock_1min / 2009-07-06

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-07-06.parquet
  size:    12.8 MB
  rows:    987,578
  symbols: 2,715

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-07-06 08:00:00	AAPL	Stock	4.9679	4.9814	4.9643	4.965	46900.0
2009-07-06 08:01:00	AAPL	Stock	4.9671	4.9671	4.9671	4.9671	25200.0
2009-07-06 08:02:00	AAPL	Stock	4.9679	4.9679	4.965	4.965	84000.0
2009-07-06 08:03:00	AAPL	Stock	4.9657	4.9657	4.9657	4.9657	9100.0
2009-07-06 08:04:00	AAPL	Stock	4.9643	4.965	4.9607	4.965	106092.0
2009-07-06 08:05:00	AAPL	Stock	4.9661	4.9661	4.9661	4.9661	2800.0
2009-07-06 08:07:00	AAPL	Stock	4.9614	4.9614	4.9614	4.9614	2800.0
2009-07-06 08:08:00	AAPL	Stock	4.9614	4.9614	4.9614	4.9614	2800.0
2009-07-06 08:12:00	AAPL	Stock	4.9632	4.9632	4.9607	4.9607	42000.0
2009-07-06 08:14:00	AAPL	Stock	4.9621	4.9621	4.9621	4.9621	5600.0
2009-07-06 08:16:00	AAPL	Stock	4.96	4.96	4.9596	4.9596	14840.0
2009-07-06 08:17:00	AAPL	Stock	4.9596	4.9596	4.9554	4.9554	137620.0
2009-07-06 08:18:00	AAPL	Stock	4.9546	4.9546	4.9532	4.9532	8400.0
2009-07-06 08:20:00	AAPL	Stock	4.9518	4.9532	4.9489	4.9489	62300.0
2009-07-06 08:21:00	AAPL	Stock	4.9493	4.9493	4.9486	4.9489	56000.0
2009-07-06 08:22:00	AAPL	Stock	4.9464	4.9486	4.9464	4.9486	233520.0
2009-07-06 08:23:00	AAPL	Stock	4.9464	4.9464	4.9464	4.9464	45360.0
2009-07-06 08:24:00	AAPL	Stock	4.9436	4.9436	4.9436	4.9436	5600.0
2009-07-06 08:25:00	AAPL	Stock	4.9432	4.9432	4.9375	4.9375	94192.0
2009-07-06 08:26:00	AAPL	Stock	4.9389	4.9486	4.9389	4.9464	64652.0
2009-07-06 08:27:00	AAPL	Stock	4.9425	4.9429	4.9425	4.9429	29680.0
2009-07-06 08:28:00	AAPL	Stock	4.9432	4.9432	4.9425	4.9425	14952.0
2009-07-06 08:29:00	AAPL	Stock	4.9436	4.9436	4.9429	4.9429	11956.0
2009-07-06 08:30:00	AAPL	Stock	4.9425	4.9464	4.9418	4.9464	58968.0
2009-07-06 08:32:00	AAPL	Stock	4.9496	4.9514	4.9454	4.9514	14952.0
2009-07-06 08:34:00	AAPL	Stock	4.9521	4.9521	4.95	4.95	11200.0
2009-07-06 08:35:00	AAPL	Stock	4.95	4.95	4.95	4.95	5600.0
2009-07-06 08:36:00	AAPL	Stock	4.9514	4.9514	4.9514	4.9514	2800.0
2009-07-06 08:37:00	AAPL	Stock	4.95	4.9518	4.95	4.9518	17472.0
2009-07-06 08:38:00	AAPL	Stock	4.9536	4.9536	4.9536	4.9536	2800.0
2009-07-06 08:39:00	AAPL	Stock	4.9532	4.9532	4.9532	4.9532	8400.0
2009-07-06 08:44:00	AAPL	Stock	4.9518	4.9518	4.9507	4.9507	11200.0
2009-07-06 08:45:00	AAPL	Stock	4.9511	4.9518	4.95	4.9518	42000.0
2009-07-06 08:46:00	AAPL	Stock	4.9518	4.9518	4.9518	4.9518	2800.0
2009-07-06 08:48:00	AAPL	Stock	4.9504	4.9504	4.95	4.95	5600.0
2009-07-06 08:49:00	AAPL	Stock	4.9511	4.9518	4.9511	4.9518	22400.0
2009-07-06 08:50:00	AAPL	Stock	4.9532	4.9532	4.9532	4.9532	2800.0
2009-07-06 08:55:00	AAPL	Stock	4.95	4.95	4.95	4.95	2800.0
2009-07-06 08:56:00	AAPL	Stock	4.9504	4.955	4.95	4.9507	16800.0
2009-07-06 08:57:00	AAPL	Stock	4.9536	4.9536	4.9536	4.9536	17780.0
2009-07-06 09:00:00	AAPL	Stock	4.9536	4.9675	4.9536	4.9675	75600.0
2009-07-06 09:02:00	AAPL	Stock	4.9589	4.9607	4.9589	4.9607	19600.0
2009-07-06 09:03:00	AAPL	Stock	4.9607	4.9607	4.9607	4.9607	8820.0
2009-07-06 09:04:00	AAPL	Stock	4.9607	4.9636	4.9607	4.9636	14000.0
2009-07-06 09:05:00	AAPL	Stock	4.9636	4.9636	4.9636	4.9636	8400.0
2009-07-06 09:06:00	AAPL	Stock	4.9636	4.9639	4.9636	4.9639	34580.0
2009-07-06 09:09:00	AAPL	Stock	4.9614	4.9614	4.9614	4.9614	8400.0
2009-07-06 09:10:00	AAPL	Stock	4.9643	4.9643	4.9643	4.9643	2800.0
2009-07-06 09:11:00	AAPL	Stock	4.9643	4.9643	4.9639	4.9639	12600.0
2009-07-06 09:12:00	AAPL	Stock	4.9675	4.9729	4.9675	4.9729	25620.0

> showing 50 of 987,578 rows — these rows as CSV

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