PREVIEW / stock_5min / 2009-12-07

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-12-07.parquet
  size:    4.6 MB
  rows:    313,977
  symbols: 3,428

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-12-07 04:15:00	AAPL	Stock	6.8611	6.8611	6.8596	6.8596	12936.0
2009-12-07 07:00:00	AAPL	Stock	6.8782	6.8786	6.8782	6.8786	5600.0
2009-12-07 07:05:00	AAPL	Stock	6.8893	6.8893	6.8893	6.8893	4116.0
2009-12-07 07:10:00	AAPL	Stock	6.8971	6.8971	6.8971	6.8971	5600.0
2009-12-07 07:25:00	AAPL	Stock	6.9039	6.9039	6.9039	6.9039	16800.0
2009-12-07 07:40:00	AAPL	Stock	6.9179	6.9179	6.9179	6.9179	11200.0
2009-12-07 07:45:00	AAPL	Stock	6.9179	6.9379	6.9179	6.9379	8400.0
2009-12-07 07:50:00	AAPL	Stock	6.9321	6.9386	6.9286	6.9286	70588.0
2009-12-07 07:55:00	AAPL	Stock	6.9318	6.9318	6.9318	6.9318	2800.0
2009-12-07 08:00:00	AAPL	Stock	6.9454	6.9464	6.9071	6.9107	172956.0
2009-12-07 08:05:00	AAPL	Stock	6.9143	6.9171	6.9114	6.9114	66164.0
2009-12-07 08:10:00	AAPL	Stock	6.9143	6.9232	6.9143	6.9232	33880.0
2009-12-07 08:15:00	AAPL	Stock	6.925	6.9286	6.925	6.925	98672.0
2009-12-07 08:20:00	AAPL	Stock	6.9214	6.9239	6.9125	6.9125	105560.0
2009-12-07 08:25:00	AAPL	Stock	6.9143	6.9143	6.9075	6.9075	107408.0
2009-12-07 08:30:00	AAPL	Stock	6.9082	6.9139	6.9071	6.9071	58800.0
2009-12-07 08:35:00	AAPL	Stock	6.9075	6.9136	6.9075	6.9121	19600.0
2009-12-07 08:40:00	AAPL	Stock	6.9121	6.9125	6.9054	6.9107	42000.0
2009-12-07 08:45:00	AAPL	Stock	6.9107	6.9136	6.9107	6.9136	90720.0
2009-12-07 08:50:00	AAPL	Stock	6.9121	6.9132	6.9089	6.9089	139748.0
2009-12-07 08:55:00	AAPL	Stock	6.9132	6.9132	6.9007	6.9021	126364.0
2009-12-07 09:00:00	AAPL	Stock	6.9046	6.9093	6.9025	6.9093	93296.0
2009-12-07 09:05:00	AAPL	Stock	6.9093	6.91	6.8975	6.8975	134876.0
2009-12-07 09:10:00	AAPL	Stock	6.8957	6.9018	6.8957	6.8993	88200.0
2009-12-07 09:15:00	AAPL	Stock	6.9011	6.9018	6.8982	6.9018	52920.0
2009-12-07 09:20:00	AAPL	Stock	6.9036	6.9036	6.9	6.9032	39284.0
2009-12-07 09:25:00	AAPL	Stock	6.8996	6.9043	6.8996	6.9043	135660.0
2009-12-07 09:30:00	AAPL	Stock	6.9043	6.9204	6.8596	6.8596	18521944.0
2009-12-07 09:35:00	AAPL	Stock	6.8614	6.87	6.8043	6.8145	30347464.0
2009-12-07 09:40:00	AAPL	Stock	6.8161	6.8189	6.7414	6.7961	47786676.0
2009-12-07 09:45:00	AAPL	Stock	6.7968	6.8336	6.7868	6.8271	26923960.0
2009-12-07 09:50:00	AAPL	Stock	6.8257	6.8457	6.8071	6.8179	22527176.0
2009-12-07 09:55:00	AAPL	Stock	6.8182	6.8332	6.7907	6.8004	15008896.0
2009-12-07 10:00:00	AAPL	Stock	6.7993	6.8139	6.7714	6.7809	17453520.0
2009-12-07 10:05:00	AAPL	Stock	6.7814	6.8071	6.7786	6.7993	17303748.0
2009-12-07 10:10:00	AAPL	Stock	6.7982	6.8132	6.7982	6.8036	12179076.0
2009-12-07 10:15:00	AAPL	Stock	6.8046	6.8054	6.7786	6.795	14020776.0
2009-12-07 10:20:00	AAPL	Stock	6.794	6.8118	6.7893	6.8104	8097488.0
2009-12-07 10:25:00	AAPL	Stock	6.809	6.8268	6.8086	6.8164	15523256.0
2009-12-07 10:30:00	AAPL	Stock	6.8164	6.8414	6.8157	6.8354	11508336.0
2009-12-07 10:35:00	AAPL	Stock	6.8354	6.8446	6.8243	6.8343	9224908.0
2009-12-07 10:40:00	AAPL	Stock	6.8343	6.8457	6.825	6.8439	9545060.0
2009-12-07 10:45:00	AAPL	Stock	6.8425	6.8493	6.8364	6.8364	5978476.0
2009-12-07 10:50:00	AAPL	Stock	6.8379	6.8571	6.8379	6.8486	8628928.0
2009-12-07 10:55:00	AAPL	Stock	6.8482	6.8618	6.8382	6.8393	8765288.0
2009-12-07 11:00:00	AAPL	Stock	6.8386	6.8457	6.8239	6.8279	7275324.0
2009-12-07 11:05:00	AAPL	Stock	6.8279	6.8321	6.8154	6.8154	5489960.0
2009-12-07 11:10:00	AAPL	Stock	6.8154	6.8207	6.8089	6.8121	5542740.0
2009-12-07 11:15:00	AAPL	Stock	6.8111	6.8139	6.7982	6.8021	5191256.0
2009-12-07 11:20:00	AAPL	Stock	6.8021	6.8075	6.7975	6.8041	4140864.0

> showing 50 of 313,977 rows — these rows as CSV

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