PREVIEW / stock_1min / 2009-01-15

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-01-15.parquet
  size:    12.7 MB
  rows:    976,728
  symbols: 2,696

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-01-15 04:18:00	AAPL	Stock	2.84	2.84	2.84	2.84	8400.0
2009-01-15 04:20:00	AAPL	Stock	2.8507	2.8507	2.8507	2.8507	5600.0
2009-01-15 04:21:00	AAPL	Stock	2.8411	2.8411	2.84	2.84	19600.0
2009-01-15 05:00:00	AAPL	Stock	2.8218	2.8218	2.8218	2.8218	5600.0
2009-01-15 05:02:00	AAPL	Stock	2.8214	2.8214	2.8214	2.8214	2800.0
2009-01-15 05:18:00	AAPL	Stock	2.8175	2.8175	2.8171	2.8171	5600.0
2009-01-15 05:24:00	AAPL	Stock	2.8171	2.8171	2.8171	2.8171	2800.0
2009-01-15 05:25:00	AAPL	Stock	2.8079	2.8079	2.8079	2.8079	2800.0
2009-01-15 05:26:00	AAPL	Stock	2.8075	2.8075	2.8075	2.8075	2800.0
2009-01-15 05:48:00	AAPL	Stock	2.825	2.825	2.825	2.825	14000.0
2009-01-15 06:05:00	AAPL	Stock	2.8125	2.8125	2.8125	2.8125	2800.0
2009-01-15 06:43:00	AAPL	Stock	2.8196	2.8214	2.8196	2.8214	26600.0
2009-01-15 06:45:00	AAPL	Stock	2.8179	2.8179	2.8179	2.8179	28000.0
2009-01-15 06:49:00	AAPL	Stock	2.8107	2.8107	2.8021	2.8021	69804.0
2009-01-15 06:50:00	AAPL	Stock	2.8036	2.8036	2.8036	2.8036	67396.0
2009-01-15 06:55:00	AAPL	Stock	2.8036	2.8036	2.8036	2.8036	23520.0
2009-01-15 06:56:00	AAPL	Stock	2.7989	2.7989	2.7989	2.7989	2800.0
2009-01-15 06:57:00	AAPL	Stock	2.8036	2.8036	2.8036	2.8036	2800.0
2009-01-15 06:58:00	AAPL	Stock	2.8043	2.8043	2.8043	2.8043	16800.0
2009-01-15 07:00:00	AAPL	Stock	2.7982	2.8179	2.7982	2.8179	43400.0
2009-01-15 07:01:00	AAPL	Stock	2.8089	2.8214	2.8018	2.8018	137200.0
2009-01-15 07:02:00	AAPL	Stock	2.8171	2.8175	2.7982	2.7982	105196.0
2009-01-15 07:04:00	AAPL	Stock	2.8046	2.8046	2.8036	2.8036	22400.0
2009-01-15 07:05:00	AAPL	Stock	2.8089	2.8089	2.8036	2.8036	126560.0
2009-01-15 07:06:00	AAPL	Stock	2.8036	2.8089	2.8036	2.8089	28000.0
2009-01-15 07:07:00	AAPL	Stock	2.8093	2.8093	2.8089	2.8089	21840.0
2009-01-15 07:08:00	AAPL	Stock	2.8039	2.8039	2.7868	2.7982	105392.0
2009-01-15 07:10:00	AAPL	Stock	2.8036	2.8093	2.8036	2.8093	14000.0
2009-01-15 07:11:00	AAPL	Stock	2.8093	2.8093	2.8093	2.8093	19600.0
2009-01-15 07:12:00	AAPL	Stock	2.8039	2.8039	2.8039	2.8039	5600.0
2009-01-15 07:13:00	AAPL	Stock	2.8111	2.8111	2.8111	2.8111	4900.0
2009-01-15 07:14:00	AAPL	Stock	2.8111	2.8143	2.8107	2.8125	204400.0
2009-01-15 07:15:00	AAPL	Stock	2.8136	2.8168	2.8136	2.8164	61600.0
2009-01-15 07:16:00	AAPL	Stock	2.8161	2.8179	2.8161	2.8161	36904.0
2009-01-15 07:17:00	AAPL	Stock	2.8189	2.825	2.8189	2.825	160776.0
2009-01-15 07:18:00	AAPL	Stock	2.8225	2.8225	2.8214	2.8214	19600.0
2009-01-15 07:19:00	AAPL	Stock	2.8214	2.8214	2.8164	2.8164	71624.0
2009-01-15 07:20:00	AAPL	Stock	2.8189	2.8189	2.8146	2.8146	25200.0
2009-01-15 07:21:00	AAPL	Stock	2.815	2.815	2.8111	2.8125	331408.0
2009-01-15 07:22:00	AAPL	Stock	2.8107	2.8132	2.8089	2.8089	22848.0
2009-01-15 07:24:00	AAPL	Stock	2.8136	2.8136	2.8136	2.8136	2800.0
2009-01-15 07:25:00	AAPL	Stock	2.8132	2.8139	2.8132	2.8136	12824.0
2009-01-15 07:26:00	AAPL	Stock	2.8136	2.8136	2.8132	2.8132	53256.0
2009-01-15 07:28:00	AAPL	Stock	2.8132	2.8143	2.8125	2.8143	26320.0
2009-01-15 07:31:00	AAPL	Stock	2.8121	2.8121	2.8121	2.8121	14000.0
2009-01-15 07:32:00	AAPL	Stock	2.8139	2.8139	2.8136	2.8136	39872.0
2009-01-15 07:33:00	AAPL	Stock	2.8136	2.8175	2.8132	2.8143	107940.0
2009-01-15 07:34:00	AAPL	Stock	2.8179	2.8179	2.8175	2.8179	19600.0
2009-01-15 07:35:00	AAPL	Stock	2.8179	2.8179	2.8068	2.8068	222544.0
2009-01-15 07:36:00	AAPL	Stock	2.8036	2.8071	2.8036	2.8071	115360.0

> showing 50 of 976,728 rows — these rows as CSV

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